A
Arne Hegefors
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!
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!