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.![Compile error]()
Any advice gratefully received
TIA
Jo.
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.
Any advice gratefully received
TIA
Jo.
Microsoft OfficeVB ScriptMicrosoft 365
Last Comment
Jo Cox
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
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
ASKER CERTIFIED SOLUTION
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
or
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