invoke macro from outside excel - auto macros

  • Thread starter Thread starter nongo
  • Start date Start date
N

nongo

I have got 2 macros to my workbook that prints the entire
active worksheet or a given single page of the worksheet.
How can I call these modules from outside excel
automatically. Say from the command line, or Inter
Explorer.

Thanks in advance.
 
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 said:
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.
Click to expand...

It is possible to do it from Internet Explorer using vbscript
though using the Application.run syntax

There's an example of opening and writing to
Excel with IE and vbscript at

http://www.rlmueller.net/Programs/XLWrite.txt

to do the same thing using asp see

http://builder.com.com/5100-6373-5072712.html#Listing F

Keith
 
Back
Top