Trying to get Excel Macro to pause will .bat file runs

[grego9]

I am trying to get an excel macro to pause while a .bat file runs. Here is my code so far:

Call Shell("Q:\IT\Quantum\XXXX.bat", vbNormalFocus)

Workbooks.Open Filename:="C:\Filename.xls"


The XXXX.bat file generates the Filename.xls file - so I need the macro to pause until the .bat file has finished running.

Any ideas?!!

thanks

[QVeen72]

Hi,

After Shell, Sleep for few seconds, do events..

'Declare This API in Form Level 
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
 
 
Call Shell("Q:\IT\Quantum\XXXX.bat", vbNormalFocus)
Sleep 10000   'Sleep for 10 seconds
DoEvents
DoEvents
Workbooks.Open Filename:="C:\Filename.xls"
 

REgards
Veena

[grego9]

Thanks Veena - but I need the macro to wait until the file has actually be saved down (the one that is generated from the XXXX.bat process) - this can take 5 minutes or it could take 3 minutes - so rather than a pause I guess I need a wait command.

I tried the command you added - but I am not too hot on the 'declare' stuff. How do I enter this API in form level

apologies for the stupid questions!







'Declare This API in Form Level
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)


Call Shell("Q:\IT\Quantum\XXXX.bat", vbNormalFocus)
Sleep 10000 'Sleep for 10 seconds
DoEvents
DoEvents
Workbooks.Open Filename:="C:\Filename.xls"
[/code]

REgards
Veena[/quote]