ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Launching a batch file (https://www.excelbanter.com/excel-programming/341153-launching-batch-file.html)

Ben[_10_]

Launching a batch file
 
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



Dave Peterson

Launching a batch file
 
Take a look at VBA's help for Shell.

Ben wrote:

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


--

Dave Peterson

Chip Pearson

Launching a batch file
 
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



"Ben" wrote in message
...
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





All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com