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"

"Joel Allen" <joelallen123@hotmail.com> wrote in message

news:u%234mMj2HKHA.3000@TK2MSFTNGP04.phx.gbl...
> 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
>