legacy dll and excel
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. |
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. |
All times are GMT +1. The time now is 10:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com