View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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