Avatar of Rob Sanders
Rob Sanders
 asked on

Problem Calling Bat File from VBS Script

I am trying to use a .vbs file to run a .bat file using the following:

"Set WshShell = WScript.CreateObject("WScript.Shell")
WSHShell.run "\\servername\folder\subfolder\batfile.bat"

but when I do it always tells me the following:

Line: 2
Char: 1
Error: The system cannot find the file specified
Code: 80070002
Source: (null)"

The location specified is definitely correct. If I change the script and location of the bat file to a local drive it runs without issue. I have no idea what is wrong and I'm not familiar with writing scripts. Any help would greatly be appreciated.
VB ScriptWindows BatchScripting Languages

Avatar of undefined
Last Comment
HainKurt

8/22/2022 - Mon
Neil Russell

does the account that the vbs script is running in have access to the server and path?
Can you execute  \\servername\folder\subfolder\batfile.bat  directly from a cmd prompt on the computer that fails to run the vbscript?

Is this called by a user or is it maybe in a GPO?
HainKurt

try

Set WshShell = WScript.CreateObject("WScript.Shell")
dim myfile = "\\servername\folder\subfolder\batfile.bat"
WSHShell.run myfile
HainKurt

or maybe

Set WshShell = WScript.CreateObject("WScript.Shell")
WSHShell.run "\\\\servername\\folder\\subfolder\\batfile.bat"
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Rob Sanders

ASKER
@NeilSr I can run the bat file manually as the user. Right now that is all I am trying to do before I attempt to run it from a GPO.

@HainKurt After implementing your change it is now saying the following when I run the .vbs file:

Line: 2
Char: 2
Error: The network path was not found.
Code: 80070035
Source: (null)
Neil Russell

May I ask why you need to run both a vbscript AND a batch file at the same time? Can you not just have a script that does it all OR have more than one login script listed in the GPO?
Rob Sanders

ASKER
In this environment when we attempt to run a bat file directly upon logon the user receives a Windows security prompt asking if they want to run the file. I have previously worked around this issue by calling the .bat file from a .vbs file. That is what I would like to do here.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
HainKurt

i am just guessing :)

maybe you have something in bat file which creates that message!!!

and you have this exactly in your vbs file

Set WshShell = WScript.CreateObject("WScript.Shell")
WSHShell.run "\\servername\folder\subfolder\batfile.bat"

Open in new window


in your original post, you have " in front
HainKurt

any log in event viewer?
Rob Sanders

ASKER
The " in front of the code is not in the actual .vbs file. The application and system event viewer logs do not show anything.

I supposed it is possible that something in the .bat file is causing the message, but again, they work when running them locally. The problem only happens when trying to run the script from a UNC or mapped drive path.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Bill Prew

I did a test of your original post and it worked fine here, so I don't think it's a VBS problem per se.  I suspect it's privilege related, etc.

~bp
Rob Sanders

ASKER
I logged on to the workstation as a domain administrator and ran the .vbs file and had the same problem just to make sure there wasn't a permissions issue.
HainKurt

any log in event viewer?
how do you run this vbs? double click, from cmd prompt?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Steve Knight

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Rob Sanders

ASKER
@HainKurt There was nothing in event viewer.

@Steve Knight Yes, there are spaces in the path. I tried adding the three sets of quotes around the path but it made no difference.
Steve Knight

OK.  can you simplify.

Make a short batch file,

@echo off
echo Running batch file %~f0
pause

Open in new window


Save that as \\server\share\batch1.cmd , i.e. short filename, no spaces in easy location on share.

Then try JUST this in a VBScript:

Set WshShell = WScript.CreateObject("WScript.Shell")
WSHShell.run """\\server\share\batch1.cmd"""

Open in new window


Start cmd.exe prompt and:
cscript yourtest.vbs
wscript yourtest.vbs

Any different?  If that works try a file with space in the path or filename.  If not how about if you run a local .cmd file.

Having just tested it like I thought earlier, I get specifically the error you mention when running a file with spaces in the name and they go away including the extra " at the beginning and end?

Steve
Rob Sanders

ASKER
With the simplified bat file I still encounter the same issue.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Rob Sanders

ASKER
wait, hold on. I didn't read your entire post. Let me try everything and get back with you.
Rob Sanders

ASKER
Set WshShell = WScript.CreateObject("WScript.Shell")
 WSHShell.run """\\servername\folder\sub folder with spaces\batfile.bat"""

I guess in all the different things I tried, I never tried this specific combination.
Rob Sanders

ASKER
Whoops, meant to mention in the above post that I just made is that was the code that finally worked and we got this resolved now.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Steve Knight

No problem... if you imagine what you type in the Wshshell.run command is what you would have to put in, say, the START command, e.g.

START \\servername\folder\sub folder\batch file.cmd

Open in new window


then it will run \\servername\folder\sub

so you would have to run it with quotes to run the whole correct path:

START "TITLE" "\\servername\folder\sub folder\batch file.cmd"

Open in new window


You have to add the title to START as the first item in " " is the title so without it the batch file does not run.

The first " starts the string, the next one escapes the one after it to include in the string which is why you end up with 3.

Steve
HainKurt

if you put your question like

WSHShell.run "\\servername\some folder\sub folder\batfile.bat"

or

WSHShell.run "\\SRV001273X\User Files\Test Files\batfile.bat"

or

just post the actual path, then you would get the answer immediately :)