We help IT Professionals succeed at work.

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


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.Compile error
Any advice gratefully received

Watch Question

Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

We'd need to see the VBA code, API Declarations, ...
Dr. KlahnPrincipal Software Engineer

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.
Peter HutchisonSenior Network Systems Specialist

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
ICT Manager
Guys. I stumbled across a PC that had a version office 365 installed (I assume a 32 bit version) which seemed to work and has solved my problem.
Thanks for your input