Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
batch file call from a macro - how ? and required batch format
Hi
Im trying to run a batch file (runit.bat) that contains the following statements: runfast.exe <temp.in interpolate.exe summit.exe del int.log del old.out ..exe are fortran files. I just saved this text file with these statements to a file named runit.bat. If I double click on the file - it will execute these sequentially as shown. Im trying to run in excel from a macro. I tried putting this in a call statement but it just flashes the DOS window real quick , doesnt run. I can call an individual program, say runfast.exe, and it runs ok. If I try to call runfast.exe by itself from within a batch file, it doesnt run either, so its not just because I have a sequence of executable statements. Im in XP, does a batch file need a special format or something to run from excel 2003? Please note my name - Im a primative VB user who likes the record button. Thanks for your time. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
batch file call from a macro - how ? and required batch format
Try
Shell ("C:\runnit.bat") Mike "VB-rookie" wrote: Hi Im trying to run a batch file (runit.bat) that contains the following statements: runfast.exe <temp.in interpolate.exe summit.exe del int.log del old.out .exe are fortran files. I just saved this text file with these statements to a file named runit.bat. If I double click on the file - it will execute these sequentially as shown. Im trying to run in excel from a macro. I tried putting this in a call statement but it just flashes the DOS window real quick , doesnt run. I can call an individual program, say runfast.exe, and it runs ok. If I try to call runfast.exe by itself from within a batch file, it doesnt run either, so its not just because I have a sequence of executable statements. Im in XP, does a batch file need a special format or something to run from excel 2003? Please note my name - Im a primative VB user who likes the record button. Thanks for your time. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
batch file call from a macro - how ? and required batch format
I'd be willing to bet that this would work
http://www.mvps.org/access/general/gen0015.htm -- HTH, Barb Reinhardt "VB-rookie" wrote: Hi Im trying to run a batch file (runit.bat) that contains the following statements: runfast.exe <temp.in interpolate.exe summit.exe del int.log del old.out .exe are fortran files. I just saved this text file with these statements to a file named runit.bat. If I double click on the file - it will execute these sequentially as shown. Im trying to run in excel from a macro. I tried putting this in a call statement but it just flashes the DOS window real quick , doesnt run. I can call an individual program, say runfast.exe, and it runs ok. If I try to call runfast.exe by itself from within a batch file, it doesnt run either, so its not just because I have a sequence of executable statements. Im in XP, does a batch file need a special format or something to run from excel 2003? Please note my name - Im a primative VB user who likes the record button. Thanks for your time. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
batch file call from a macro - how ? and required batch format
This still doesnt work, but it explained to me what the "/c" does in the call command. If I omit that, it leaves the DOS window open. It shows Im in My Documents folder, which I guess is my default, but this is not where the program is, even though I called out the complete path to the program in the call statement. I need to figure out how to direct it to the proper directory. This helped some Barb thank you. "Barb Reinhardt" wrote: I'd be willing to bet that this would work http://www.mvps.org/access/general/gen0015.htm -- HTH, Barb Reinhardt "VB-rookie" wrote: Hi Im trying to run a batch file (runit.bat) that contains the following statements: runfast.exe <temp.in interpolate.exe summit.exe del int.log del old.out .exe are fortran files. I just saved this text file with these statements to a file named runit.bat. If I double click on the file - it will execute these sequentially as shown. Im trying to run in excel from a macro. I tried putting this in a call statement but it just flashes the DOS window real quick , doesnt run. I can call an individual program, say runfast.exe, and it runs ok. If I try to call runfast.exe by itself from within a batch file, it doesnt run either, so its not just because I have a sequence of executable statements. Im in XP, does a batch file need a special format or something to run from excel 2003? Please note my name - Im a primative VB user who likes the record button. Thanks for your time. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
batch file call from a macro - how ? and required batch format
You might be needing the "/k" switch instead of the "/c" switch. When you
use the Shell function to run cmd.exe which then runs your batch file, the VBA routine doesn't wait for the batch file to complete before running the lines that follow in your routine. Where exactly are you placing the batch file? Are you retrieving any output from your fortran exe files or do you just want them to run and know that the two file deletions at the end of your batch file happen? It may end up being easier to use Shell to run each of your fortran executable files and then delete int.log and old.out from your VBA routine rather than run the batch file at all. Steve Yandl "VB-rookie" wrote in message ... This still doesnt work, but it explained to me what the "/c" does in the call command. If I omit that, it leaves the DOS window open. It shows Im in My Documents folder, which I guess is my default, but this is not where the program is, even though I called out the complete path to the program in the call statement. I need to figure out how to direct it to the proper directory. This helped some Barb thank you. "Barb Reinhardt" wrote: I'd be willing to bet that this would work http://www.mvps.org/access/general/gen0015.htm -- HTH, Barb Reinhardt "VB-rookie" wrote: Hi Im trying to run a batch file (runit.bat) that contains the following statements: runfast.exe <temp.in interpolate.exe summit.exe del int.log del old.out .exe are fortran files. I just saved this text file with these statements to a file named runit.bat. If I double click on the file - it will execute these sequentially as shown. Im trying to run in excel from a macro. I tried putting this in a call statement but it just flashes the DOS window real quick , doesnt run. I can call an individual program, say runfast.exe, and it runs ok. If I try to call runfast.exe by itself from within a batch file, it doesnt run either, so its not just because I have a sequence of executable statements. Im in XP, does a batch file need a special format or something to run from excel 2003? Please note my name - Im a primative VB user who likes the record button. Thanks for your time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call a batch file from an Excel Macro | Excel Discussion (Misc queries) | |||
Call a batch file from an Excel Macro | Excel Discussion (Misc queries) | |||
Run Excel Macro through Batch file | Excel Programming | |||
Help To Create Batch/Macro Required | Excel Programming | |||
Macro to activate a Batch file ! | Excel Programming |