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.