Hello,
I'm trying to write a batch file that opens 2 Excel sheets and launches one macro that performs actions on both files.
So far I have a batch file that launches Excel, opens both files and activates the one from which the Macro must be run. But I am struggling to call the Macro as it is stored in the Personal.xlsb file and not in either spreadsheets.
I tried to post the code I had so far but I keep getting an error saying I can't post any links until I have posted a few times...I'm using Application.Run to call the Macro but that is not working at all!!
Help would be very much appreciated!!
Bookmarks