forums.silverfrost.com

[MGGM]

Hi:

Newbie on sight!

I am trying to call a FORTRAN DLL from VBA Excel, and I get the following error (Can't find DLL entry point FEXACT in....). The FORTRAN subroutine is rather complicated (it comes from: http://jblevins.org/mirror/amiller/fexact.zip -> FEXACT.f90 file). I had to modify it a bit, since it was a module driven by another program.

I made sure I had added $dec attributes before compiling & slink-ing it:

SUBROUTINE FEXACT (nrow, ncol, table, ldtabl, expect, percnt, emin, prt, pre)
!dec$ attributes dllexport, stdcall, alias:'FEXACT', :: FEXACT

But the VBA wrapper gives the entry point error.

Option Base 1
Option Explicit
Public Declare Sub FEXACT Lib "E:\Test\fexact.dll" _
(ByRef NROW As Long, ByRef NCOL As Long, ByRef TABLE As Double, ByRef LDTABL As Long, ByRef EXPECT As Double, ByRef PERCNT As Double, ByRef EMIN As Double, ByRef PRT As Double, ByRef PRE As Double)

Any ideas/hints/pointers?

Thank in avance,
MartaGG

[MGGM]

I'm really stuck on that.

THanks,
Marta GG

[JohnCampbell]

I don't think that you will get much help on using !dec$ codings from this Silverfrost Fortran forum.

I suggest that you contact the Intel� Visual Fortran Compiler for Windows forum for discussion of this problem.

John

[MGGM]

MGG