problems runnig exe from VBA

[xxxmudpie]

I'm trying to run a compiled Fortran code from excel. The DOS window shows up briefly, but nothing happens - it should create a few output files. I checked using explorer and it as accessed the file at that time.
Obviously, I've clicked on the .exe and it works fine on its own.
So I made a .bat file that runs the .exe. and called that from excel, just to see...same thing. However if I double click on the .bat file on its own no problem.
Any clues? It seems like Excel isn't allowing the program time to finish and cutting off early?
Here's what I use to execute files in excel:
"ReturnValue = Shell(ThisWorkbook.Path & "\testy.bat", 1)"

any help very gratefully received
thanks

 

[PHV]

You may try this:
CreateObject("WScript.Shell").Run Chr(34) & ThisWorkbook.Path & "\testy.bat" & Chr(34), 1, True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[fumei]

Or using a Wait within Excel?

Gerry
My paintings and sculpture