View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
VB-rookie VB-rookie is offline
external usenet poster
 
Posts: 3
Default 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.