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.


Mohan wrote:

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