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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is the syntax to execute a batch file using VBA? 1

Status
Not open for further replies.
Apollo6

Apollo6

Technical User
Jan 27, 2000
418
US
I have a batch file that ftpz several files onto a server. I want to allow the user to launch this from an existing .XLA project(from a custom menu) inside Excel. Is this possible?

Thanks in advance for any suggestions.
 
Sort by date Sort by votes
Some variation of this should do the trick:
Code: 
Private Sub CommandButton1_Click()
  Shell "C:\test.bat", 1
End Sub
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
955
morechocolate
morechocolate
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
784
hermanlaksko
hermanlaksko
thanhthanh12
  • Locked
  • Question
Help vba
Replies
3
Views
488
combo
combo
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
575
mikrom
mikrom
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
964
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top