Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
invoke macro from outside excel - auto macros
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
invoke macro from outside excel - auto macros
"Jim Rech" wrote in message ... 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. 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-507...ml#Listing%20F Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get userform Cancel button to invoke Exit Sub in calling macro? | New Users to Excel | |||
How do I invoke a call in Excel | Excel Discussion (Misc queries) | |||
HELP: Setting CNTL-SHIFT-F to invoke Excel2007 macro | Excel Discussion (Misc queries) | |||
How can I invoke running a macro from within an "IF" function. | Excel Worksheet Functions | |||
add data to combo box in excel then invoke macro | Excel Worksheet Functions |