Calling a Fortran DLL in VBA

[Roman2]

Hi
I'm new to both... Fortran and VB / VBA ... and I have a simple question... is it possible to call a Fortran DLL from VBA?
I try to get data out of Excel and do the calculation in Fortran... which sends the information back to VBA in order to save it in the Excel file...

Is what I try to do even possible? I read a lot about calling Fortran DLLs in VB Code... but never about calling it in VBA.

Thanks a lot for your help

Greetings

[anthonyrichards]

This problem has arisen so often here thata simple search of the forum for 'EXCEL Fortran DLL' should throw up lots of helpful links for you.

[Roman2]

hehe okay... sorry about that :)

[DavidWhite]

Quoting - Roman

hehe okay... sorry about that :)

Among the threads you may find, this one may be useful.

I recommend that you get dependency walker (free from dependencywalker.com) to help sort out missing DLL's and errors that occur from time to time. Getting the argumnet types and calling conventions on both sides of the call is critical.

I have at least 3 apps running with multiple users all from Excel through VBA to Fortran DLL. If you want any assistance - search the forum and ask for help.

Regards,

David

[anthonyrichards]

..or you could try this recent thread...

http://software.intel.com/en-us/forums/showthread.php?t=70615

I attach the zipped archive mentioned there, with two added screenshots showing the EXCEL worksheet plus VBA code.

[Roman2]

well thanks for the help @ all :) I will try it

greez