| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Batch in excel
Hello,
I have what I believe is an easy question. Is there a way from excel' VB to call batch files? If so, would you please show me how. Thank -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Batch in excel
You can Shell to the bat file. E.g.,
Shell "H:\test.bat" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "calculus87 " wrote in message ... Hello, I have what I believe is an easy question. Is there a way from excel's VB to call batch files? If so, would you please show me how. Thanks --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Batch in excel
Interesting,
I am a bit new to this, so let me get this straight. You just cal this command Shell "H:\test.bat" and it will execute the bat file -- Message posted from http://www.ExcelForum.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Batch in excel
Yes, you can call the Shell method, passing it the name of the
bat file, and it will execute the bat file immediately. Note that execution will immediate proceed to the line of code following Shell, without waiting for the bat file to complete. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "calculus87 " wrote in message ... Interesting, I am a bit new to this, so let me get this straight. You just call this command Shell "H:\test.bat" and it will execute the bat file? --- Message posted from http://www.ExcelForum.com/ |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Batch in excel
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel run a batch file? | Excel Discussion (Misc queries) | |||
| run batch job from each row - how to insert run batch function per row? | Excel Discussion (Misc queries) | |||
| Excel to Run a Batch File?!? | New Users to Excel | |||
| Excel in batch mode | Excel Programming | |||
| How can I batch print Excel files? | Excel Programming | |||
Linear Mode
