Hello,
I also tried this, and initially it appeared to work. my executable is a
compiled fortran program. The executable works ok when I run it outside of
Excel, but when I use the shell command, it doesnt.

Sub run_for()
Dim retApp As Double
retApp = Shell("L:\methods\for.exe", vbMinimizedFocus)

End Sub

The .exe accesses an input file from within L:\methods. When I execute from
the subroutine, does it need a full pathname in the exe as opposed to just
the filename?

Bird


"robertdeniro" wrote:


-*Shell "C:\windows\ap1.exe", vbNormalFocus*-

Unless Ap1.exe is located in a folder that's in the system path, you'll
have to specify the full path to the file.


--
robertdeniro
------------------------------------------------------------------------
robertdeniro's Profile: http://www.excelforum.com/member.php...o&userid=14173
View this thread: http://www.excelforum.com/showthread...hreadid=396096