Avatar of Jo Cox
Jo Cox
Flag for United Kingdom of Great Britain and Northern Ireland asked on

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

Microsoft OfficeVB ScriptMicrosoft 365

Avatar of undefined
Last Comment
Jo Cox

8/22/2022 - Mon
Daniel Pineault

We'd need to see the VBA code, API Declarations, ...
Dr. Klahn

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 Hutchison

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
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Jo Cox

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question