legacy dll and excel

[Juggernath]

I made some dll libraries in Fortran (Microsoft Fortran 4.0 released in
1997, i think) and c.
Is it possible to add this dll's to reference for VBA project in Excel (VBA

tools> references) ant then simply call functions compiled in dll, instead

of declaring dll at the begining of VBA code?
I've got this idea since i found out that .NET classes could be referenced
similar way.

 

[Rob Bovey]

No, you can't reference a standard DLL. Only COM DLLs can be accessed by
the Tools/References menu. You will have to write Declare statements to
access the functions contained in your DLL (assuming they have been written
and exported in a format that VBA can work with).

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *