ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can you wait for the SHELL command to terminate ? (https://www.excelbanter.com/excel-programming/278320-re-how-can-you-wait-shell-command-terminate.html)

Dave Peterson[_3_]

How can you wait for the SHELL command to terminate ?
 
MS has a solution at:

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

Here's a link to a nice ShellAndWait function that does that.
http://groups.google.com/groups?thre...%40tkmsftngp03

jmoffat wrote:

As the help file points out:

"Note: By default, the Shell function runs other programs
asynchronously. This means that a program started with Shell might not
finish executing before the statements following the Shell function are
executed."

This implies there is a way to cause execution to halt until the shell
command is completed.

Has anyone found a way to do this ?

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/


--

Dave Peterson


jmoffat

How can you wait for the SHELL command to terminate ?
 
Thanks a lot Dave - this is exactly what I was looking for.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/



All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com