View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.