I have two excel files,
C:\B.xlsm, both have macros defined in "Workbook_Open()", when opened, will run, make some computation, then exit.
Is it possible to use command line, batch file, etc, to run the two excel files, in sequence?
By run, I mean B shall start after A finish.
I understand that Windows Scheduled Task can define multiple Actions, which will start in sequence, but the next action doesn't wait the previous one to finish. So this is not enough here.