The problem's with the space in your path.  Try using three double quotes,
as in:

shell.run """ <file:///\\Mcplsv04\mprint-acctfin\BAT\OR_PACU%20Stats.bat>
\\Mcplsv04\mprint-acctfin\BAT\OR_PACU Stats.bat"""

which, when it's resolved by VB, will put single double quotes around the
path.

 

Rich McNeil

Boston Software Systems

866 653 5105 x 813

www.bostonworkstation.com

 

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rodgers Chase
Sent: Thursday, April 03, 2008 11:16 AM
To: [email protected]
Subject: [Talk] BAT problem

 

I shell out multiple BAT processes within my BWS script and I just added a
new one.

If I double click the BAT file, it runs fine and extracts the data I need.

However, when BWS runs it, it gives me the following error:

Run-time error '-2147024894 (800700002)':

Method 'Run' of object 'IWshShell3' failed

Here is the code I'm running:

Set shell = CreateObject("wscript.shell")

shell.run "\\Mcplsv04\mprint-acctfin\BAT\OR_PACU Stats.bat"

Set shell = Nothing

Wait 4

Any feedback is appreciated.

Chase Rodgers
Financial Reporting Manager
Medical Center of Plano
(214-473-7490
/[EMAIL PROTECTED] 

Reply via email to