|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
August 17th 09, 08:30 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
syntax
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 
|
| Ads |
|
#2
August 17th 09, 11:18 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
syntax
Nevermind, got it working. This is what works:
Myshell.Run chr(34)+"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE"+chr(34)+chr(34)+"\\t gps8\documents\Company Documents-Public\PM Department\Link Ron's Database to PMTool\Ship Date sync.mdb"+chr(34)+ " /x mcrFixTask" "Joel Allen" wrote in message ... 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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| restrict with wildcard @SQL syntax | Gordon Prince | Outlook and VBA | 6 | February 21st 09 11:22 AM |
| someone can help me to correct my syntax and my all Macro | פקודת מאקרו בערבית | Outlook and VBA | 1 | December 23rd 07 10:28 PM |
| please help with syntax | joe schmo | Outlook and VBA | 1 | May 4th 07 10:58 PM |
| syntax of calendar link | MikeL | Outlook - General Queries | 4 | June 21st 06 11:12 PM |
| Invalid Syntax Error?? | F. Edwin Felty | Outlook Express | 5 | March 31st 06 05:02 PM |
Linear Mode
