Public Function RunAndWait(ComLine As String) As Boolean
' запустить приложение и дождаться окончания его работы
', ShowFlag As VbAppWinStyle
'--------------------------------------------------------------------------------
'
'Использование:
'
'If RunAndWait("rar.exe a regbackup system.dat user.dat", "c:\windows", vbNormalFocus) Then
'    MsgBox  "Registry backuped!" 
'End If
    Dim si As STARTUPINFO
    Dim pi As PROCESS_INFORMATION
    si.wShowWindow = vbNormalFocus
    si.dwFlags = STARTF_USESHOWWINDOW
    If CreateProcess(vbNullString, ComLine, ByVal  0 &, ByVal  0 &, False,  0 , _
                            ByVal  0 &,  "c:\" , si, pi) Then
        WaitForSingleObject pi.hProcess, INFINITE
        CloseHandle pi.hProcess
        RunAndWait = True
        Exit Function
    End If
    RunAndWait = False
End Function

Public Type PROCESS_INFORMATION
        hProcess As Long
        hThread As Long
        dwProcessId As Long
        dwThreadId As Long
End Type

Public 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

Declare Function CreateProcess Lib  "kernel32"  Alias  "CreateProcessA"  _
(ByVal lpApplicationName As String, _
ByVal lpCommandLine As String, lpProcessAttributes As Any, _
lpThreadAttributes As Any, ByVal bInheritHandles As Long, _
ByVal dwCreationFlags As Long, lpEnvironment As Any, _
ByVal lpCurrentDriectory As String, lpStartupInfo As STARTUPINFO, _
lpProcessInformation As PROCESS_INFORMATION) As Long
Declare Function CloseHandle Lib  "kernel32"  (ByVal hObject As Long) As Long
Declare Function WaitForSingleObject Lib  "kernel32"  (ByVal hHandle As Long, _
ByVal dwMilliseconds As Long) As Long