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