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.
--
Rob van Gelder -
http://www.vangelder.co.nz/excel
"Mohan" wrote in message
...
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