ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can excel run a batch file? (https://www.excelbanter.com/excel-discussion-misc-queries/232460-can-excel-run-batch-file.html)

Tom

Can excel run a batch file?
 
How do I create a macro to run a batch file (abc.bat), after attaching it to
a button? I realize Excel has to carry out this task out itself. If not, is
there a way around it by first getting into the command prompt?

TIA
Tom



jaf

Can excel run a batch file?
 
Hi Tom,
Shell "c:\your path\abc.bat"

John


"Tom" wrote in message ...
How do I create a macro to run a batch file (abc.bat), after attaching it to
a button? I realize Excel has to carry out this task out itself. If not, is
there a way around it by first getting into the command prompt?

TIA
Tom



Tom

Can excel run a batch file?
 
Hi John,

It works perfectly. Thanks.

Tom

"jaf" wrote in message
...
Hi Tom,
Shell "c:\your path\abc.bat"

John


"Tom" wrote in message
...
How do I create a macro to run a batch file (abc.bat), after attaching it
to a button? I realize Excel has to carry out this task out itself. If
not, is there a way around it by first getting into the command prompt?

TIA
Tom





All times are GMT +1. The time now is 06:25 AM.

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