Fortran DLL and Excel – How to mesh them together

Making a fortran DLL and using it with excel has two distinct advantage.

1. We don’t need to re write the fortran code to a vb code.

2. Fortran DLL is significantly faster than the vba code.

And with all this we get goodness of excel with the power of fortran.

It is with this idea, I had created few fortran dll’s over the years and used them with excel in my professional and personal projects.

The graphics and data handling capability coupled with fortran’s numerical engine had served me well.

If you are interested in how to mesh the two, the following posts should be useful to you.

Fortran and Excel – good fit for marriage

How to create fortran DLL with intel compiler using Visual Studio?

How to create fortran DLL with intel compiler without visual studio?

How to create fortran DLL with gfortran open source compiler?

Advertisements

4 thoughts on “Fortran DLL and Excel – How to mesh them together

  1. Pingback: How to create Fortran DLL in Visual Studio with Intel Fortran compiler « SukhbinderSingh.com

  2. Although I have been programing with fortran for many years, I have mixed up fortran dll’s with excel only recently and your posts were of a great help and saved me quite a lot of time.
    However I still have a problem : I cannot find a way to create a dll working with excel 64bits in office 2010.
    My compilers (both intel V11.0 et gfortran V4.5.2) are both installed in a 32bits Windows XP machine : is there any chance to force them to produce 64bits dll’s compatible so that they would nicely interface with VBA7 in a 64bits Windows 7 machine ?
    Any idea would be most welcomed.
    Thanks & regards,
    Thierry

    Like

  3. Pingback: Few Toy Programs to Mesh Excel and Fortran together | SukhbinderSingh.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s