Command line, how can i send this???

[mtheriault2000]

Hello to all

I got a command line that i can use to do a capture screen procees. This line is working fine when placed directly on the execute box in the Windows start menu

"C:\Program Files\HyperSnap 6\HprSnap6.exe" -snap:x4:y80:w1675:h880 -hidden -quicksave,1,1,999999 -save:jpg "C:\Documents and Settings\Martin\Mes documents\Bourse\Sonray_Graphique\Graphique_2\Sonraysnap.jpg"

How can i sent it via a macro. I have tried with Shell function as i do with others, but this line contain some space and Excel does no like it ( ithink the problem is arround that). How can i resolve this macro

Martin

 

[mtheriault2000]

Re: Command line, how can i send this??? (Resolve)

Hi I resolve the problem by adding CHR(34) where i needed the " " " quote mark

Sub Open_hypersnap()
Dim hypersnap As String
hypersnap = Shell(Chr(34) & "C:\Program Files\HyperSnap 6\HprSnap6.exe" & Chr(34) & " -snap:x4:y80:w1675:h880 -hidden -quicksave,1,1,999999 -save:jpg " & Chr(34) & "C:\Documents and Settings\Martin\Mes documents\Bourse\Sonray_Graphique\Graphique_2\Sonraysnap.jpg" & Chr(34))
End Sub

Martin