Fortran DLL and VBA

[chinhqnguyen]

I am trying to run a FORTRAN 90 DLL in a VBA Excel application. My fortran program has a lot of mathematical functions such as: COS, SIN, SQRT,NINT, etc. I use Compaq Visual Fortran 6.6 compiler to create the DLL file. Each time I try to run this DLL in my VBA program the following error message appears:

?Run time error 53, File Not Found ...?.

When I remove those mathematical functions from my Fortran codes and leave simple operations there, the DLL just works fine. I appreciate if you can help me in this regard.

[Steven_L_Intel1]

http://compaq.com/fortran/visual/redist.html

Steve

[chinhqnguyen]

Hi Steve,

Thank you for your respond. I tried what you mentioned and I got the same error message

"Run time error '53'
File Not Found ......"

Do you have any other suggestion?

- Peter -
my email addresses are
CQTran@cessna.textron.com
chinhqnguyen@yahoo.com

[Steven_L_Intel1]

Make sure your DLL is built in a "Release Configuration" and not "Debug Configuration".

Steve

[chinhqnguyen]

Hi Steve,

I GOT IT , Steve :-) :-) :-) :-)
Exactly as you said, my project has been built in "Debug Configuration" so it caused me many troubles when I tried to call Fortran subroutines in the VBA program. After changing to "Release Configuration", my program is running very fine.
Thanks you for your help.

Again thank you very...very...very... much, Steve.
Have a good day, Steve

- Peter -