calling fortran dll from VBA excel function

[EJD1]

I'm trying to create a function in Excel which will use a dll created in Fortran. The idea is that a name gets input in Excel and the dll returns an integer appropriate to the name. I set this name to ByVal and the integer to Byref in the VB and declare both with Attributes REFERENCE in the fortran. But it does not seem to pass the integer back to Excel.

Any help very much appreciated,

Ed

 

[CaKiwi]

Fortan arguments are always by reference. Try passing the name as Byref.

CaKiwi

"I love mankind, it's people I can't stand" - Linus Van Pelt