shell command

[CooterBrown]

Hi.. How do I get this command to work:

Sh.Run "cmd /C ""C:\documents and settings\ThisUser\desktop\TESTMACRO\CallQuery.bat""", 1, True

after replacing the path C:\documents... with the variable

gstrAppPath = Workbooks("ThisBook").Path

Thanks..

Coot

 

[PHV]

Sh.Run "cmd /C """ & gstrAppPath & "\CallQuery.bat""", 1, True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CooterBrown]

Thanks.. It get confusing for a rookie when all them quotes are involved... I tried everything..but that..:? )

Worked perfectly.