run bat file from vb

[JeffGrant]

Hi All,

Just wondering why I can a run bat file from the command prompt, but when I run

Sub RunPYScript()

Dim wsh As Object
Set wsh = VBA.CreateObject("WScript.Shell")
Dim waitOnReturn As Boolean: waitOnReturn = True
Dim windowStyle As Integer: windowStyle = 1
wsh.Run "C:\Users\jeff\Desktop\Betfair Bot\RUNPY.BAT", windowStyle, waitOnReturn
MsgBox "Wait for Data to Download"
End Sub

it gives me a runtime error

I do run other external programs direct using the EXECCMD command and that works file, but running a bat file is throwing me.

Any assistance greatly received.

 

[John_w]

Try:

    wsh.Run "cmd.exe /c ""C:\Users\jeff\Desktop\Betfair Bot\RUNPY.BAT""", windowStyle, waitOnReturn

 

[rollis13]

It's probably because WScript doesn't accept the space between Betfair Bot in your path, try instead:

wsh.Run """C:\Users\jeff\Desktop\Betfair Bot\RUNPY.BAT""", WindowStyle, waitOnReturn

Ps. Hi to all.

 

[JeffGrant]

Thanks Folks...

It is just funny how the proverbial DOS rules still hang around. I figured it would be something simple like that.