VBA在64bit Excel中使用?
我有個Excel項目,是在32位Excel 2003中開發的,但是在64bit Excel2010,會報如下錯誤:
Compile error:
The code in this project must be updated for use on 64-bit systems.
Please review and update Declare statements and then mark them with the PtrSafe attribute.
誰知道怎麼解決?
我在網上找了資料如下:
?Original Statement: Private Declare Function
?Amended Statement: Private Declare PtrSafe Function
?Long → to → LongPtr
?LongPtr → to → LongLong
?and some "Long" are supposed to remain the same, depending on what they do
[解决办法]
http://club.excelhome.net/thread-809769-1-1.html
看这个能不能帮到你。