Hi Devon Couldn't get the .bat file method going though have managed to get it working with the inclusion of the * out the front and //x rather than /x as per below syntax.
wd 'winexec *"C:\Program Files\Microsoft Office\Office11\MSAccess.exe" "q:\Finance\Budget Management\path\pathology.mdb" //x import' cheers john -----Original Message----- From: Devon McCormick [mailto:[EMAIL PROTECTED] Sent: Thursday, 31 May 2007 12:15 PM To: Programming forum Subject: Re: [Jprogramming] winexec command line Does something like this work? str=. '"c:\Program Files\Microsoft Office\Office11\MSAccess.exe" "q:\Finance\Budget Management\path\pathology.mdb" /x import' str fwrite batfl=. 'c:\temp\impdb.bat' wd 'winexec ',batfl On 5/30/07, Oleg Kobchenko <[EMAIL PROTECTED]> wrote: > > wd 'winexec *"notepad" "c:\boot.ini"' > > --- "Saunders, John (TQEH)" <[EMAIL PROTECTED]> wrote: > > > Hi Tom, thanks ; tried that and got the below error > > > > > > > > |domain error: wd > > > > | wd'winexec "c:\Program Files\Microsoft > > Office\Office11\MSAccess.exe""q:\Finance\Budget > > Management\path\pathology.mdb /x import"' > > > > |[-0] > > > > wd 'qer' > > > > bad style : 0 > > > > > > > > > > > > -----Original Message----- > > > > > > > > Tom Arneson wrote: > > > > > > > > Try: > > > > wd 'winexec "c:\Program Files\Microsoft Office\Office11\MSAccess.exe" > > "q:\Finance\Budget Management\path\pathology.mdb /x import"' > > > > > > > > -----Original Message----- > > From: programming-bounces at jsoftware.com > > <http://www.jsoftware.com/cgi-bin/mailman/listinfo/programming> > > [mailto:programming-bounces at jsoftware.com > > <http://www.jsoftware.com/cgi-bin/mailman/listinfo/programming> ] On > > Behalf Of Saunders, John > > (TQEH) > > Sent: Wednesday, May 30, 2007 20:44 > > To: Programming forum > > Subject: [Jprogramming] winexec command line > > > > Hello everyone; I'm trying to call an access macro from my J script and > > the below example tries to open budget.mdb rather than following the > > full file path due to a space in the folder name, can anyone please > > suggest a way to get around this ( I can't rename the folder) > > > > > > > > wd 'winexec "c:\Program Files\Microsoft Office\Office11\MSAccess.exe > > q:\Finance\Budget Management\path\pathology.mdb /x import"' > > > > > > > > many thanks > > > > John > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > John Saunders > > > > Senior Budget Officer > > > > The Queen Elizabeth Hospital > > > > Ph : 8222 6516 > > > > Fax: 8222 6188 > > > > This e-mail may contain confidential information, which also may be > > legally privileged. Only the intended recipient(s) may access, use, > > distribute or copy this e-mail. If this e-mail is received in error, > > please inform the sender by return e-mail and delete the original. If > > there are doubts about the validity of this message, please contact the > > sender by telephone. It is the recipient's responsibility to check the > > e-mail and any attached files for viruses. > > > > > > > > ---------------------------------------------------------------------- > > For information about J forums see http://www.jsoftware.com/forums.htm > > > > > > > ________________________________________________________________________ ____________Looking > for a deal? Find great prices on flights and hotels with Yahoo! FareChase. > http://farechase.yahoo.com/ > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > -- Devon McCormick, CFA ^me^ at acm. org is my preferred e-mail ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
