DOS BATCH program to open workbook, run macros

[dwr0211]

I need a DOS .bat program to open a work book and then I need to run two separate macros.

 

[kpark91]

How about making a .bat program to just open the workbook
and letting the workbook run the two separate macros by using ThisWorkbook_Open() event.

If you have done enough research for your problem, you shouldn't have problem with opening a file.

anyways as for the workbook_Open event, you could also search up.

Calling subs/macros is shown in this code

Call Macro1 'Macro1 is the name of the macro.

 

[ElBombay]

I couldn't fins the Excel equivelents in a quick search but in Lorus you would create a file called auto123 with a "\0" macro that opens the workbook you want, then have another "\0" macro in that file. HTH