invoke macro from outside excel - auto macros
Macros cannot be called from outside Excel, e.g., from the command line.
The only macros that run automatically when a workbook opens is Sub
Auto_Open in a regular module and Sub Workbook_Open in the ThisWorkbook
module. You could run your code from either of them, perhaps asking the
user via MsgBox if he wants to print.
--
Jim Rech
Excel MVP
|