Excel 2007 : Backwards Compatibility from a 64 Bit VBA Macro

Hi All -

I'm hoping someone can help me resolve this issue. I've looked high and low for a solution everywhere on various search engines and no one has a solution.

Here's the scenario:

I built a VBA Macro in Excel 2010 (64-bit) and saved it as an "XLS" (Excel 97 - 2003) file with the hopes that my clients can use the file on either 32 bit or 64 bit version of MS Excel (i.e. Excel 2003/2007). After building the macro, I realized that because I'm using userforms, I need to use the PtrSafe command to ensure that my macro works in Excel 2010.

After building the macro, I gave it to my client who is using Excel 2007 (32 bit). Apparently, they're getting compile errors right when they open the macro. It has to do with the fact that the PtrSafe command is not recognized in Excel2007.

How do I ensure that my 64 bit Excel 2010 macro has the proper code in place so it's backwards compatible for also Excel 2007 32 bit versions? I've read numerous articles and everyone is talking about the move from 32 bit to 64 bit tools, but not the other way.

The code in question is the following:

Please Login or Register  to view this content.

Any help trying to resolve this is VERY much appreciated.

Hello there

Because you searched already, maybe you know this:

http://msdn.microsoft.com/en-us/library/ee691831.aspx

Search for "Application Programming Interface Compatibility" on that page

Will explain the compiler problems

I don't know since, as I said, they should not get errors there as the compiler should be ignoring that code. Are you 100% sure that that is the offending code?

Side note: PtrSafe has nothing whatsoever to do with userforms as you suggest in your original post - it relates to API calls and memory addresses.

I just put your code in a 32 bit Excel 2010 module and no errors were noticed.

The code compiles in 2007 too. Perhaps it is the fact that the syntax checker will turn it red that is confusing your users.