http://msdn2.microsoft.com/en-us/library/ms683189.aspx

STILL_ACTIVE is a constant, the actual value does not matter


Arne Hegefors wrote:
Hi! I have a macro that opens another program. It then is supposed to loop
while that other program is still active. This usually works fine but now
there seems to be a problem. I think the other program is working on
something else to begin with. I would really appreciate some help with what
this STILL_ACTIVE means. I get STILL_ACTIVE = 259. What does that mean?

Dim hProc As Long
Dim lExitCode As Long
Dim ACCESS_TYPE
Dim STILL_ACTIVE
Dim lTaskID As Long

ACCESS_TYPE = &H400
STILL_ACTIVE = &H103

'start the bat file
lTaskID = RunBatFile
'get the process handle

MsgBox "stop"

hProc = OpenProcess(ACCESS_TYPE, False, lTaskID)
If Err < 0 Then
Exit Sub
End If
'Wait for the batch program to finish
Do
GetExitCodeProcess hProc, lExitCode
DoEvents
Loop While lExitCode = STILL_ACTIVE

Any help much appreciated!