Excel to Run a Batch File?!?

[carla]

Hi

I am running Office 2003. I have designed an excel spreadsheet using
various macros. I now need a macro designed that can run a batch file.
Is this possible?

Hope you guys can help!

Thanks Alot

Carla

 

[Gord Dibben]

Carla

Sub Run_Batch()
Dim taskID As Variant
On Error Resume Next
Shell ("C:\yourbatch.bat"), vbNormalFocus
If Err <> 0 Then _
MsgBox "yourbatch.bat is Missing"
End Sub


Gord Dibben MS Excel MVP

 

[Chip Pearson]

See the Shell function. If you need to wait for the Shell'd process to end
before continuing your code execution, see
http://www.cpearson.com/excel/shellandwait.htm.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)