Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
waiting for an .exe file that runs
Hi all,
I accomplish to make an .exe file run but the call sub i've written below seem to execute without caring at the end of the .exe file. Only if I put the msgbox, this can block excel in running and let the .exe file finish. any help? the rilevant part of the code is: Option Explicit Private Type STARTUPINFO cb As Long lpReserved As String lpDesktop As String lpTitle As String dwX As Long dwY As Long dwXSize As Long dwYSize As Long dwXCountChars As Long dwYCountChars As Long dwFillAttribute As Long dwFlags As Long wShowWindow As Integer cbReserved2 As Integer lpReserved2 As Long hStdInput As Long hStdOutput As Long hStdError As Long End Type Private Type PROCESS_INFORMATION hProcess As Long hThread As Long dwProcessID As Long dwThreadId As Long End Type Private Declare Function WaitForSingleObject _ Lib "kernel32" (ByVal hHandle As Long, _ ByVal dwMilliseconds As Long) As Long Private Declare Function CreateProcessA _ Lib "kernel32" (ByVal lpApplicationName As String, _ ByVal lpCommandLine As String, _ ByVal lpProcessAttributes As Long, _ ByVal lpThreadAttributes As Long, _ ByVal bInheritHandles As Long, _ ByVal dwCreationFlags As Long, _ ByVal lpEnvironment As Long, _ ByVal lpCurrentDirectory As String, _ lpStartupInfo As STARTUPINFO, _ lpProcessInformation As PROCESS_INFORMATION) As Long Private Declare Function GetExitCodeProcess _ Lib "kernel32" (ByVal hProcess As Long, _ lpExitCode As Long) As Long Private Declare Function CloseHandle Lib "kernel32" _ (ByVal hObject As Long) As Long Private Const NORMAL_PRIORITY_CLASS = 32 Sub test() ExecCmd "Y:\programs\Sel.exe", 2000, True 'MsgBox "ok", vbInformation Call GetTextFile Call copy End Sub Function ExecCmd(sCmdLine As String, _ lmSecsWait As Long, _ Optional bShowWindow As Boolean) As Long 'will start an external process and 'wait till this process is finished 'returns -1 if successfull and -1 if not '----------------------------------------- Dim proc As PROCESS_INFORMATION Dim Start As STARTUPINFO Dim lReturn As Long 'Initialize the STARTUPINFO structu With Start .cb = Len(Start) .dwFlags = 1 'hexadecimal would be &H1 If bShowWindow Then .wShowWindow = 1 End If End With 'Start the shelled application: lReturn = CreateProcessA(sCmdLine, _ vbNullString, _ 0, _ 0, _ 1, _ NORMAL_PRIORITY_CLASS, _ 0, _ "Y:\RUNNING\Valassis\gemelli", _ Start, _ proc) 'Wait for the shelled application to finish: lReturn = WaitForSingleObject(proc.hProcess, lmSecsWait) test1 GetExitCodeProcess proc.hProcess, lReturn CloseHandle proc.hThread CloseHandle proc.hProcess ExecCmd = lReturn End Function Sub test1() Dim cSK As clsSendKeys Set cSK = New clsSendKeys cSK.SendString "TEST", False cSK.PressKeyVK keyReturn cSK.PressKeyVK keyReturn End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
waiting for an .exe file that runs
Look for the "Shell and Wait" example in he
http://www.appspro.com/Tips/VBA%20Tips.htm -- Hope that helps. Vergel Adriano "Marco" wrote: Hi all, I accomplish to make an .exe file run but the call sub i've written below seem to execute without caring at the end of the .exe file. Only if I put the msgbox, this can block excel in running and let the .exe file finish. any help? the rilevant part of the code is: Option Explicit Private Type STARTUPINFO cb As Long lpReserved As String lpDesktop As String lpTitle As String dwX As Long dwY As Long dwXSize As Long dwYSize As Long dwXCountChars As Long dwYCountChars As Long dwFillAttribute As Long dwFlags As Long wShowWindow As Integer cbReserved2 As Integer lpReserved2 As Long hStdInput As Long hStdOutput As Long hStdError As Long End Type Private Type PROCESS_INFORMATION hProcess As Long hThread As Long dwProcessID As Long dwThreadId As Long End Type Private Declare Function WaitForSingleObject _ Lib "kernel32" (ByVal hHandle As Long, _ ByVal dwMilliseconds As Long) As Long Private Declare Function CreateProcessA _ Lib "kernel32" (ByVal lpApplicationName As String, _ ByVal lpCommandLine As String, _ ByVal lpProcessAttributes As Long, _ ByVal lpThreadAttributes As Long, _ ByVal bInheritHandles As Long, _ ByVal dwCreationFlags As Long, _ ByVal lpEnvironment As Long, _ ByVal lpCurrentDirectory As String, _ lpStartupInfo As STARTUPINFO, _ lpProcessInformation As PROCESS_INFORMATION) As Long Private Declare Function GetExitCodeProcess _ Lib "kernel32" (ByVal hProcess As Long, _ lpExitCode As Long) As Long Private Declare Function CloseHandle Lib "kernel32" _ (ByVal hObject As Long) As Long Private Const NORMAL_PRIORITY_CLASS = 32 Sub test() ExecCmd "Y:\programs\Sel.exe", 2000, True 'MsgBox "ok", vbInformation Call GetTextFile Call copy End Sub Function ExecCmd(sCmdLine As String, _ lmSecsWait As Long, _ Optional bShowWindow As Boolean) As Long 'will start an external process and 'wait till this process is finished 'returns -1 if successfull and -1 if not '----------------------------------------- Dim proc As PROCESS_INFORMATION Dim Start As STARTUPINFO Dim lReturn As Long 'Initialize the STARTUPINFO structu With Start .cb = Len(Start) .dwFlags = 1 'hexadecimal would be &H1 If bShowWindow Then .wShowWindow = 1 End If End With 'Start the shelled application: lReturn = CreateProcessA(sCmdLine, _ vbNullString, _ 0, _ 0, _ 1, _ NORMAL_PRIORITY_CLASS, _ 0, _ "Y:\RUNNING\Valassis\gemelli", _ Start, _ proc) 'Wait for the shelled application to finish: lReturn = WaitForSingleObject(proc.hProcess, lmSecsWait) test1 GetExitCodeProcess proc.hProcess, lReturn CloseHandle proc.hThread CloseHandle proc.hProcess ExecCmd = lReturn End Function Sub test1() Dim cSK As clsSendKeys Set cSK = New clsSendKeys cSK.SendString "TEST", False cSK.PressKeyVK keyReturn cSK.PressKeyVK keyReturn End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
waiting for an .exe file that runs
thanks a lot
I found the solution. Marco |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
Pausing or waiting in VBA | Excel Programming | |||
Waiting... | Excel Programming | |||
in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz | Excel Worksheet Functions | |||
waiting | Excel Programming |