syntax

[Joel Allen]

Outlook 2003 SP3

Hi,

I'm trying to run this with my script code. This is what works from the RUN
command line:

This DOES work:
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE"
"\\tgps8\documents\Company Documents-Public\PM Department\Link Ron's
Database to PMTool\Ship Date sync.mdb" /x mcrFixTask

But within the my script, I just can't get the format right. I've tried
multiple variations with no luck.

This DOES NOT work:
Myshell.Run "C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE"
"\\tgps8\documents\Company Documents-Public\PM Department\Link Ron's
Database to PMTool\Ship Date sync.mdb" /x mcrFixTask


This DOES NOT work:
Myshell.Run chr(34)+"C:\Program Files\Microsoft
Office\Office11\MSACCESS.EXE"+chr(34) +chr(34)+"\\tgps8\documents\Company
Documents-Public\PM Department\Link Ron's Database to PMTool\Ship Date
sync.mdb"+chr(34) /x mcrFixTask

Just to test it, this DOES work:
Myshell.Run chr(34)+"C:\Program Files\Microsoft
Office\Office11\MSACCESS.EXE"+chr(34)



Can someone help me get the syntax right for this?:

Myshell.Run chr(34)+"C:\Program Files\Microsoft
Office\Office11\MSACCESS.EXE"+chr(34) +chr(34)+"\\tgps8\documents\Company
Documents-Public\PM Department\Link Ron's Database to PMTool\Ship Date
sync.mdb"+chr(34) /x mcrFixTask


Thanks,
Joel

 

[Joel Allen]

Nevermind, got it working. This is what works:

Myshell.Run chr(34)+"C:\Program Files\Microsoft
Office\Office11\MSACCESS.EXE"+chr(34)+chr(34)+"\\tgps8\documents\Company
Documents-Public\PM Department\Link Ron's Database to PMTool\Ship Date
sync.mdb"+chr(34)+ " /x mcrFixTask"