32-bit Excel 2010 Run Macro Fine, but 64-bit Excel 2010 Doesn't

[ransomedbyfire]

I have been trying to get a really old macro that someone else wrote with API calls for a certain program to run on a 64-bit computer with a 64-bit version of Excel 2010. I have been testing it on another computer that someone else is letting me use for testing purposes. I just found out that this test computer does have 64-bit Windows but is running a 32-bit version of Excel 2010.

The macro I am testing almost works on the test computer, except for a few problems specific to that computer that do not involve Excel; but I am not having much luck with the other computer with 64-bit Excel.

Does the fact that the code runs fairly well on the test computer indicate that it should be able to run on the other computer? Or does 64-bit Excel 2010 run totally differently in terms of APIs than 32-bit Excel 2010?

 

[Smitty]

Or does 64-bit Excel 2010 run totally differently in terms of APIs than 32-bit Excel 2010?

Bingo (but it's not just API's). That's why you'll find that not too many people have switched to 64-Bit Office. It's too much of a pain in the a$$, especially with existing add-ins.

If you post the code someone might be able to help you get it set up for 64-Bit.

 

[ransomedbyfire]

Is it just a matter of adjusting things like ptrsafe functions? I've been told that some API calls do not work with 64-bit Excel, period. Is this true? And how to I know if these calls can work? Trial and error until I give up?

 

[Smitty]

PtrSafe is one of the big things, yes. As to API's some will work with some adjusting, while some won't; it's all a matter of what they do. I personally don't do much with API's though, so I'll wait until someone who does can come along and give a better answer.