starting .bat file from excel VBA

[Mark]

Hi,
I'm using
AppFile = "C:\P_R_O_G\_xls_ZAG\F_FAKT.BAT"
Shell "Start" & AppFile
to start my dos program from VBA macro in Excel and VBA answer is "File not
found".
What am I doing wrong? (path is correct, file exist)

 

[Dave Peterson]

Without testing...

Shell "Start " & AppFile

An extra space after Start.

And if AppFile could ever have spaces embedded:

Shell "Start " & chr(34) & AppFile & chr(34)

Chr(34) is the double quote character, but it's still untested.

 

[Gary''s Student]

Try:

Sub Macro1()
x = Shell("cmd.exe /c C:\P_R_O_G\_xls_ZAG\F_FAKT.BAT", 1)
End Sub