batch file call from a macro - how ? and required batch format

[VB-rookie]

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.

 

[Mike H]

Try

Shell ("C:\runnit.bat")

Mike

 

[Barb Reinhardt]

I'd be willing to bet that this would work

http://www.mvps.org/access/general/gen0015.htm

 

[VB-rookie]

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.

 

[Steve Yandl]

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