.Wait for Shell program to finish 2

[CooterBrown]

I am issuing this command in a VBA macro:
Shell ("C:\documents and settings\ssc\desktop\BKRSDDS\callCopyIMPF.bat")

How would I get the program to wait for this program to finish executing before proceeding.
Thanks,
Coot

 

[PHV]

Dim Sh As Object
Set Sh = CreateObject("WScript.Shell")
Sh.Run "cmd /C ""C:\documents and settings\ssc\desktop\BKRSDDS\callCopyIMPF.bat""", 1, True
Set Sh = Nothing



Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[CooterBrown]

That worked...

Thanks!