running a batch file

[Mohan]

Is there a way to run a batch file (dos command file) from
vba code?

To upgrade the existing Excel application, I need to put
some dll in the local drive.. I have a batch file to copy
this from the network to local drive..

Is there a way I can run this batch file in the Excel
Auto_Open module?

Thank you

 

[Dave Peterson]

Take a look at Shell in VBA's help.

But maybe better would be looking at FileCopy in the help.

Then you may not even need that .bat file.

 

[Tom Ogilvy]

Look in VBA help as the Shell command.

 

[Rob van Gelder]

Shell is your answer.

The trouble is, Shell will set the batch file to run, but then immediately
continue VBA code execution.
So if your code straight after the Shell command relies on what actions of
the batch file, then you could run into problems because the batch file may
or may not have finished.

Do an internet search for ShellWait if the above is an issue for you.