View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default legacy dll and excel


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 *


"Juggernath" wrote in message
...
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.