call excel 2003 macro from command line

K

Keven

How do you call an excel macro from a command line.
For this instance I cannot use the AUTO_OPEN Macro and I
need a way to open the excel workbook from windows
scheduler and have the macro PERSONAL.XLR!testformat
execute.
I found out that in access you can use the /X (macro name)
option but that does not work in excel
Any help would be greatly appreciated.

Thanks in advance.
Keven
 
K

Kevin Beckham

Can you add a reference to the PERSONAL.XLR workbook in the
workbook you want to open, then, in the Workbook_Open
procedure, add a call to testformat

Kevin Beckham
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to call Excel add-in macro from a button… 1
How to launch Macro/Code form command line 2
Excel TWO Instances of Excel One watching Other 3
Stop Command Question 4
Excel 2000 Macro 4
Excel command line 5
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Running an excel macro from the task manager 2

Top