We help IT Professionals succeed at work.

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

TIA
Jo.
Comment
Watch Question

Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

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

Commented:
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

Commented:
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
Commented:
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