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

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

Halim



"Chris" wrote:

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

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:

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