Home |
Search |
Today's Posts |
#1
|
|||
|
|||
run vbs from vba Syntax
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run vbs from vba Syntax
"Jerry V" wrote:
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is Access VBA syntax different from Excel syntax? | Excel Programming | |||
Syntax HELP | Excel Discussion (Misc queries) | |||
Help with syntax | Excel Programming | |||
Syntax help! | Excel Programming | |||
syntax | Excel Programming |