Batch update existing macro

[twfurst]

Hello,

I have a few thousand Excel workbooks that each contain a macro that needs to be updated. Is there any way that I can do this a batch fashion and not need to open each and every workbook?

Thank you in advance.

Tom Furst

 

[TheRobRush]

Not really without a third party tool.

 

[TheRobRush]

you could, however, use VBA to create an Excel Add-In that worked in all your books.

 

[TheRobRush]

or make a personal vba workbook that excel loads every time it's opened. that would also make it useable by multiple books