Running a DOS/CMD command with parameters executed from VBA

[merebag]

I have a routine that I runs fine from a dos/cmd manually that executes a shell script on a Linux box. I would love to have a button on an Access form that executes the same command using VBA.



Here is the command I want to run that runs fine from a cmd window by running a script on the Linux box called UpdateTimesheet.sh.

start C:\plink.exe -ssh -P 22 user@server -pw password echo %1 ^| sh -x "/bin/UpdateTimesheet.sh"

I know about the Shell() command in vba, however, I think the double-quotes " in the path of the shell to run the command gets in the way.

Any clues?

[John_G]

Just use double quotes inside the path/parameter string:

start C:\plink.exe -ssh -P 22 user@server -pw password echo %1 ^| sh -x ""/bin/UpdateTimesheet.sh""