B baldev Jul 4, 2003 #1 does anyone know how to run excel from a command line incorporating Excel macro eg Call Excel.exe /macro=mymacro
does anyone know how to run excel from a command line incorporating Excel macro eg Call Excel.exe /macro=mymacro
B Bob Phillips Jul 4, 2003 #2 You would be bets to put the macro code in the workbook as an automatically run code, either by call it Auto_Open and place in a normal code module put it in the Workbook_Open event code in the ThisWorkbook code module. If you want this to happen when you start Excel rather than just one specific workbook, put it in Personal.xls.
You would be bets to put the macro code in the workbook as an automatically run code, either by call it Auto_Open and place in a normal code module put it in the Workbook_Open event code in the ThisWorkbook code module. If you want this to happen when you start Excel rather than just one specific workbook, put it in Personal.xls.
