VBA for 64-bit and 32-bit

[yawnzzzz]

Hi,

Below is code that works on 64-bit. I know by switching the LongLong's to Long and removing PtrSafe it works on 32-bit, but I'm wondering how to write this to work on both?

Please Login or Register  to view this content.

[dominicb]

Good evening yawnzzzz

Not tested, nor can I test it as I don't have Excel 2010 however I think you're going to need two versions of the macro: one for 32 bit and one for 64 bit. You will need to read the Application.Version value to see what the user is running and run the appropriate version.

HTH

DominicB

[yawnzzzz]

From what I've gathered, this should work:

Please Login or Register  to view this content.

But I'm not sure about the correct syntax for this:

Please Login or Register  to view this content.

[yawnzzzz]

I just surrounded it like the above, and it appears to work. I thought there might be a simpler solution though.

Please Login or Register  to view this content.