Making code written in 32-bit vba compatible with 64-bit vba

**blh** · 08-18-2014, 08:52 AM

Good day,

I am new to excel vba.

I was wondering how can I make my code (written in excel 2010 32 bit) compatible to run by someone who has excel 2010 64-bit?

Thanks

**romperstomper** · 08-18-2014, 08:57 AM

It depends. Do you use API calls, or activex controls that aren't from the Forms library? If not, you shouldn't really need any changes.

**blh** · 08-18-2014, 09:30 AM

I think so yes. It gives 2 errors "1) Compilation error in hidden module: " and 2) Could not load an object because it is not available on this machine

**romperstomper** · 08-18-2014, 09:32 AM

We'll need the code to rectify part 1.
With part 2 you are probably out of luck. (one of the reasons that Microsoft recommends you stick with 32 bit Excel unless you need to work with really big files is that a lot of controls do not have 64 bit versions - including many MS ones)