Forum Discussion
Running macro code externally with vbs and batch file
I have a macro that copies data from multiple workbooks into a Master wkbook. I am only able to do this by running the macro from the Master wkbk. However I want to be able to run this code externall...
Haytham Amairah Can you please take a look at my issue
Hi,
I've never tried to run macros outside Excel before!
But after searching the web I found a good way to do so in this https://stackoverflow.com/questions/10232150/run-excel-macro-from-outside-excel-using-vbscript-from-command-line.
I've tried the solution in the last reply, and it works just fine.
Regards