Link to home
Start Free TrialLog in
Avatar of Jo Cox
Jo CoxFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Excel 32 bit macro won't run on 64Bit machine

Hi,

We have a spreadsheet that was supplied to us and now we have upgraded to widows 10 and the Office 365 version of Excel; now the Macros won't run.

See attached files.

I have been informed that it was compiled with the old 32 VB libraries and needs recompiling with newer 64 bit libraries.

I am at a loss as to how to do this or if this assertion is correct.User generated image
Any advice gratefully received

TIA
Jo.
Avatar of Daniel Pineault
Daniel Pineault

We'd need to see the VBA code, API Declarations, ...
Side note:  We saw this same issue in a similar question about two weeks ago but I can't find it.  Perhaps someone else can dig it up.
The Macros will probably need recompiling using Visual Studio or the express versions to run under Office 64 bit.
See this article: https://www.experts-exchange.com/questions/27579775/Windows7-64-bit-and-Office-64-bit-considerations-running-Excel.html
ASKER CERTIFIED SOLUTION
Avatar of Jo Cox
Jo Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial