How to send a command line to Windows torun an external application

[mtheriault2000]

Hello

I have done it in the past, but just can't remember how.

I need to send a command line like
"C:\Program Files (x86)\HyperSnap 7\HprSnap7.exe" -snap:x3602:y155:w1432:h830 -save:jpg "g:\testsnap\asnap1.jpg"

This open my Snap picture application, take a snap at a give location and save the image to a jpg format at a given location

This command line work whell usingWindows. Now, I want tot send it from Excel vba

Martin

 

[diddi]

I use this in my projects and it works well

Public Sub ShellAndWait(ByVal PathName As String, Optional WindowState)
    Dim hProg As Long, hProcess As Long, ExitCode As Long

    If IsMissing(WindowState) Then WindowState = 1
    hProg = Shell(PathName, WindowState)

    hProcess = OpenProcess(&H400, False, hProg)
    Do
        GetExitCodeProcess hProcess, ExitCode
        DoEvents
    Loop While ExitCode = &H103
End Sub

then :

    ShellandWait ("C:\Program Files (x86)\HyperSnap 7\HprSnap7.exe" -snap:x3602:y155:w1432:h830 -save:jpg "g:\testsnap\asnap1.jpg")

 

[mtheriault2000]

That is what I was looking for ... Shell command..

Many thanks

Martin

 

[mtheriault2000]

What could be wrong with the 2' shell command
Both file are under the same directory

Dim retval As Long

retval = Shell("C:\Program Files (x86)\HyperSnap 7\HprSnap7.exe" & " -hidden -newwin -snap:x3602:y155:w1432:h830 -save:jpg " & "g:\testsnap\asnap1.jpg -exit")
retval = Shell("C:\Program Files (x86)\HyperSnap 7\cameraclick1.wav")

Excel give me an error

If I copy the string to Windows Execute box, the .wav file is played

Martin

 

[diddi]

i think you have to shell to an exe. windows is probably using the default exe lookup to determine which exe is being loaded before the .wav is opened. try using the sndPlaySound32 API call to play the .wav directly without shelling