stephenpovey
New Member
- Joined
- Dec 19, 2005
- Messages
- 5
Hi, I'm trying to run a bat file from a vba macro. I've used x = shell("AllCopy.bat",1) and it runs but it doesn't do what its supposed to (i.e copy files into folders). please help!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
bat file run
- Thread starter stephenpovey
- Start date
Kenneth Hobson
Well-known Member
- Joined
- Feb 6, 2007
- Messages
- 3,181
- Office Version
- 365
- Platform
- Windows
The cmd /c open a DOS window and closes it after it completes the task. The other commands are DOS commands. You can type the command at DOS prompt and a /? to get help or Help Commandname.
Dir *.* lists the contents of the current folder. > is a redirection operator that sends the output of the Dir command to the text file on the right. Of course vbHide hides the DOS window opened by cmd.
Dir *.* lists the contents of the current folder. > is a redirection operator that sends the output of the Dir command to the text file on the right. Of course vbHide hides the DOS window opened by cmd.
Upvote
0
Excel Facts
Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Similar threads
- Solved
