run vbs from vba Syntax

[Jerry V]

i'm trying to run convert2pdf.vbs from vba:

Call Shell("WScript.exe """ & ThisWorkbook.Path & "\Convert2PDF.vbs"
vbMinimizedNoFocus)

Get message Syntax convert2pdf.vbs <Filename>

Can't figure out how to do this

 

[joeu2004]

Call Shell("WScript.exe """ & ThisWorkbook.Path & "\Convert2PDF.vbs",
vbMinimizedNoFocus)

Get message Syntax convert2pdf.vbs <Filename>
Can't figure out how to do this.

You are missing a double-quote after the path name. The correct syntax is:

Call Shell("WScript.exe """ & ThisWorkbook.Path & _
"\Convert2PDF.vbs""", vbMinimizedNoFocus)

or to minimize misreading in certain fonts:

Call Shell("WScript.exe " & Chr(34) & ThisWorkbook.Path & _
"\Convert2PDF.vbs" & Chr(34), vbMinimizedNoFocus)