Does anyone know how to run an Excel Marco at DOS prompt?

Posted by Alex on August 21, 2000 9:39 AM

Hi!
Does anyone know how to run an Excel Marco at DOS prompt?

Thanks for your help!

Alex Chen

Posted by Michael Liu on August 23, 0100 6:44 AM

One method is to make sure your macro is run with Auto_Open
and then from DOS, you can open the file using the command line.\

Ex:
C:\> "C:\Program Files\msoffice\office\excel" "H:\test.xls"