Lots of my macros for X5 seem to be broken with X6. How can I browse for a folder? Also what does this mean and how do I mark declare statements with a PtrSafe attribute?
---------------------------Microsoft Visual Basic for Applications---------------------------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.---------------------------OK Help ---------------------------
I just found this Microsoft page that explains how to update - add the word PtrSafe immediately after the declaration. Eg Declare Function [name] becomes Declare PtrSafe Function [name].
Most Macros will work just fine in X6 (64-Bit) however as you have seen those macros that use WinAPI calls need to be updated. Here is another page that is really helpful as they provide example to some of the more common calls:
Microsoft also provides common definitions for VBA7 that are very helpful and saves some typing, just copy and paste what you need:
-Shelby