64 Bit VBA updates batch job

[somesoldiers]

Hi All

how would I go about updating thousands of workbooks which were created on 32 bit so that they can be opened in 64 bit without errors?
I understand how to update the declarations and LongPtr manually but I would like to do this programmatically across many workbooks in a folder.

I have tried the below, where i have the adjusted module in my 64 bit workbook and use it to replace the module in the 32 bit, which would work in theory but the Compile error once the first 32 bit workbook is opened stops the code from running

VBA to automatically replace Modules in several workbooks

Hello everyone. This is my first time posting here. I have a workbook that my firm has been using over the past two years. This workbook has macros in it and we have been updating those macros, from time to time, by creating an updating workbook that replaces the modules in each workbook. We...

www.mrexcel.com

is there any way to suppress this and keep the code moving? or can anyone suggest an alternative. I haven't had much luck with google

Thanks
Noel

 

[RoryA]

Untested, but you could try setting application.automationsecurity = msoAutomationSecurityForceDisable before opening the workbooks?

 

[somesoldiers]

Untested, but you could try setting application.automationsecurity = msoAutomationSecurityForceDisable before opening the workbooks?

thanks Rory

that answered my specific question alright

also to say I wasn't able to get the replace module method working, instead I just went with looping through the folder and changing all the files to xlsx.
Most of our wbs are checklists that have already been signed off so don't require the code any longer so this seemed like the simpler option