Category Archives: Link to dll

Trigonometric Functions – dll

Posted on 11/12/2008 by dougaj4

I have converted the trigonometric functions presented in this earlier post into a Fortran dll.  The dll and associated spreadsheet and add-in files can be downloaded from here. This file and the associated file Trig.dll provide trigonometric and hyperbolic functions not … Continue reading →

Posted in Excel, Link to dll, Maths, Newton, UDFs | Tagged , , , , , , | 2 Comments

Linking Excel to Fortran – 2

Posted on 04/12/2008 by dougaj4

In this post the procedures described for C++ here will be replicated for Fortran: The spreadsheet, fortran source code, and compiled dll described in this code may be downloaded from Cubic.zip As always, it is better to use the downloaded code, … Continue reading →

Posted in Excel, Fortran, Link to dll, Maths, UDFs, Uncategorized, VBA | Tagged , , , , , | 23 Comments

Linking Excel to Fortran

Posted on 01/12/2008 by dougaj4

An earlier series of posts described how to link Excel to programs written in C or C++.  The same advantages of increased security and performance may be obtained by linking to Fortran programs with the additional advantages: Many specialist engineering and … Continue reading →

Posted in Excel, Link to dll, VBA | Tagged , , | 20 Comments

Silverfrost Personal Fortran

Posted on 24/11/2008 by dougaj4

Silverfrost Personal Fortran is a Fortran95 compiler that is free for personal use.  According to the suppliers: “With Silverfrost FTN95: Fortran for Windows you can create console based, conventional Windows® and Microsoft .NET applications. Silverfrost FTN95 is the only compiler that … Continue reading →

Posted in Computing - general, Excel, Fortran, Link to dll, Newton, VBA | Tagged , , , | 1 Comment

Linking Excel to C – 3; Avoiding bottlenecks

Posted on 08/09/2008 by dougaj4

The previous post in this series included a C dll to solve cubic polynomial equations that could be called from VBA.  The performance of this routine is compared with a VBA routine using a similar algorithm in the sceenshot below (rows … Continue reading →

Posted in Arrays, Excel, Link to dll, UDFs, VBA | Tagged , , , | 2 Comments