Shell Function

[loveperson]

Hello,
I facing the problem in this coding.

Dim dblRetVal As Double
dblRetVal = Shell("CountdownTime.exe", vbNormalFocus)
'Function when countdown timer completed
tmpkey = True

This code will call the EXE file for the countdown timer, when the dountdown timer EXE File is completed then the code of tmpkey = true will start running. But when I use the above code it will run at the same time, but I dun want.

Anybody can help in the coding???????

[Roelf]

See this thread (http://www.codingforums.com/showthread.php?t=40351&highlight=shell+wait)

[loveperson]

Thanks ur information. I can sucess running the shell but I want to add another function inside. Which is when the exe file running, the user are allow to press some key like "Esc" key to exit the shell function. Do you have any idea?