View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Randall Arnold[_2_] Randall Arnold[_2_] is offline
external usenet poster
 
Posts: 17
Default Excel macro on a DOS command line

I'm pretty sure he'll want the (now obsolete) sub Auto_Open(), or the more
current WorkBook_Open event. I don't think Auto_Execute is supported.

Randall Arnold

"jaf" wrote in message
...
Hi Richard,
No. You can open the workbook, and if it contains a macro "Auto_Execute()"
it will run.

excel.exe path\filename.xls


--

John

johnf202 at hotmail dot com


"Richard" wrote in message
...
Is there a way to run an Excel macro on a DOS command
line? Something that just run a macro and then exits Excel.

I looked in Help, but don't see any command line switch
that does this.

Any suggestion is appreciated. Thanks in advance.