Synchronous execution using shell function

[Chris]

Hi,

I can start my external application using the shell command and after about
15s it generates a txt file which I then want to process in Excel. How do I
make Excel wait for the application to terminate before processes the code
after the shell command.

Any advice is greatly appreciated.

Thanks
Chris

 

[Halim]

use :
If Application.Wait(Now + TimeValue("0:00:02")) Then
'your code here
End If

 

[Stefi]

From Tom Ogilvy:

http://support.microsoft.com/?id=214248
XL2000: How to Force Macro Code to Wait for Outside Procedure

http://support.microsoft.com/?id=129796
HOWTO: 32-Bit App Can Determine When a Shelled Process Ends

http://support.microsoft.com/?id=147392
XL: How to Force Macro Code to Wait for Outside Procedure

Regards,
Stefi


„Chris†ezt írta: