Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running a .bat or .cmd file from VBA ? 1

Status
Not open for further replies.
pradipto

pradipto

Programmer
Joined
Apr 29, 2002
Messages
22
Location
US
How can you run a .bat or .cmd file from VBA ? The Shell command can only .exe files and not .cmd or .bat files.

Please help.
 
Sort by date Sort by votes
Here is a URL to a tek-tips thread. PHV suggested a solution in it.


Cmd = """C:\Documents and Settings\Paul\My Documents\My Bits & Pieces\C_Dir.bat"""
Set sh = CreateObject("WScript.Shell")
RC = sh.Run(Cmd, 1, True)
 
Upvote 0 Downvote
Thanks Zygor. I had the same problem mentioned in the post. Need to put that """ (triple quotes).

Regards.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rj771972
  • Question Question
Powerpoint VBA - Assign manipulate object
Replies
1
Views
189
rj771972
rj771972
Andrzejek
  • Locked
  • Question Question
Outlook VBA - Trust access
Replies
3
Views
1K
hermanlaksko
hermanlaksko
thanhthanh12
  • Locked
  • Question Question
Help vba
Replies
3
Views
897
combo
combo
remeng
  • Locked
  • Question Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
5K
dhookom
dhookom
SLW89
  • Locked
  • Question Question
VBA newbie needs help
Replies
4
Views
822
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top