MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Does anyone know how to run a Excel marco on DOS batch file?


Posted by Alex on August 18, 2000 12:31 PM

Hi!
I have some Excel Marco. I have to run these Marco on DOS Batch file. Can I do that? How?

Thanks a lot!


Posted by Ivan Moala on August 18, 0100 2:22 PM


Sub DOS_Run()

Dim BatchProc As Variant

BatchProc = Shell("compress.bat", 6)

End Sub


Have a look @ shell command in VBA help files
for more info


Ivan

Posted by Alex on August 18, 0100 3:34 PM

-------------------------
Hi Ivan,

Thanks your answer!
But my question is " Can I run Excel Marco at DOS prompt?" Do you know how to do that?

Thanks a lot!

Alex Chen