Shell Compile error calling program from excel VB

[searlerm]

Hi all

I wonder whether anyone can help me with this one please...

I am trying to call an external application from within Excel VB but am getting a "Compile error - Expected list separator or )" message. The command line is as below and I have simply prefixed it with "shell(". The command line works from a run prompt but not within VB - Can anyone kindly assist please?


shell("C:/Program Files/Skyewright/programs/ImportPlus.exe" -action multiple -datatype syma -input ..\import\syma\custom\IBEXSYST-02.syma -mode nosynergy -path3p "X:/L Clients/L Limited/Sagedata/ACCDATA/" -user3p manager)

Many thanks

 

[bkpchs237]

searlerm,
I can't be sure, but my gut tells me it's a syntax error involving the quotation marks. The shell command only has 2 arguments separated by a comma. The first argument, which is the only one you are using, is one text argument not usually having sets of quotation marks. This may sound weird, but try only placing quotation marks in the beginning and at the end of the entire text command and retry. I have something similar and it seems to work then.

Hope this helps.