bat file run

Datsmart

Well-known Member

Joined

Jun 19, 2003

Messages

7,985

• Mar 13, 2007

• #2

This line of code will run the AUTOEXEC.BAT file;

Code:

Shell "C:\WINDOWS\system32\cmd.exe" & " C:\AUTOEXEC.BAT"

If your batch file runs but doesn't do what it is suposed to do that is a different issue.

 

Upvote 0

Oorang

Well-known Member

Joined

Mar 4, 2005

Messages

2,071

• Mar 13, 2007

• #3

Just to expand a bit on John's totally accurate reply (if I may):
If you use cmd.exe without specifying the path, shell will actually use the path(s) specified in the system environment variable "Path". So it is generally preferable to use cmd.exe with no path. one other random thought... If you use the command switch /c the bat file window will autoclose. So you could make it run silently like so:

Code:

VBA.Shell "cmd.exe /c c:\autoexec.bat", vbHide

One other thing. If you are on a Windows 98 Machine (and I think ME). You will need to use "command.exe" instead of "cmd.exe".

 

Upvote 0

Datsmart

Well-known Member

Joined

Jun 19, 2003

Messages

7,985

• Mar 13, 2007

• #4

Oorang,

Didn't know that. Thanks for the info. I will add it to my notes file.

 

Upvote 0

respree

Active Member

Joined

Apr 14, 2003

Messages

258

• Mar 13, 2007

• #5

Isn't he trying to run a batch file called allcopy.bat, not autoexecute.bat?

 

Upvote 0

Datsmart

Well-known Member

Joined

Jun 19, 2003

Messages

7,985

• Mar 13, 2007

• #6

respree,

You are correct, I just pasted an example of the syntax that worked for me in the past. I should have edited it to show his "allcopy.bat" file.

 

Upvote 0

S

stephenpovey

New Member

Joined

Dec 19, 2005

Messages

5

• Mar 14, 2007

• #7

Shell thanks

Thanks guys, I'll try the cmd.exe route, will surely work! steve

 

Upvote 0

joefrench

Active Member

Joined

Oct 4, 2006

Messages

357

• Jul 9, 2007

• #8

Is it possible to run a .bat file in a random directory?

I have a .bat file that deletes old versions of design files. I am working on creating an app that will run the purge.bat file to a given dir, zip all files in that dir then delete all files not including the zip.

Edit (added text below):
This is basically what I am looking at:

Code:

Shell "cmd.exe cd \\server\constant dir\constant dir\random dir\random.dir\" purge.bat

Open the system window, change directory to a directory dictated by an excel entry, run the .bat file.

 

Upvote 0

Kenneth Hobson

Well-known Member

Joined

Feb 6, 2007

Messages

3,181

Office Version

1. 365

Platform

1. Windows

• Jul 9, 2007

• #9

Joe, this is an old thread so I'm not sure how it relates.

You have several issues here. UNC paths are not available like that in a DOS Shell. You can't change to a folder and drive fron another drive like that anyway. If you can't do it in a DOS shell, you can't do it with the Shell() command.

If you need a UNC, try using the DOS command Subst and make a virtual drive for the UNC. You can the change to the "drive" in a shell and then use cd but in this case, use VBA's CHDIR.

Even so, I would code the BAT file to accept a parameter and use %1 in the BAT file to do something with the passed string such as a subfolder.

Here is an example:

Code:

Sub t()
ChDir "c:\myfiles\excel"
Shell "cmd /c dir *.* > c:\t.txt", vbHide
End Sub

 

Upvote 0

joefrench

Active Member

Joined

Oct 4, 2006

Messages

357

• Jul 28, 2007

• #10

Kenneth,

Could you please post what

Code:

Shell "cmd /c dir *.* > c:\t.txt", vbHide

means so I can figure out what it is that I need to place into this?

Thank you

 

Upvote 0