MrExcel Publishing
Your One Stop for Excel Tips & Solutions

run batch file from macro


Posted by Arjan Coolegem on October 30, 2001 5:13 AM

hi,

how di i run an batch file from an macro ?

and how do i add additional parameters to in?

(like c:\start.bat %1 )

thanks

Arjan


Posted by Richard S on October 30, 2001 2:07 PM

I got this command from a post a number of weeks ago. Have no idea what it means but it appearsto work.
Call Shell("x:\yourfile.bat", vbNormalFocus)
Just insert it in your macro
Richard