Launching a batch file

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Is it possible to launch a batch file from within an Excel macro. If so what
is the command I need in VBA assuming the batch file is in
c:\belfry\convert.bat
Thank you
 
Take a look at VBA's help for Shell.
Is it possible to launch a batch file from within an Excel macro. If so what
is the command I need in VBA assuming the batch file is in
c:\belfry\convert.bat
Thank you
Click to expand...
 
Use the Shell command. E.g.,

Shell "c:\belfry\convert.bat", vbNormalFocus


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top