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

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

Look in VBA help as the Shell command.

--
Regards,
Tom Ogilvy

"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

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