Recent Comments
Tag Archives: VBA
Trigonometric Functions – dll
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 dll, Excel, Fortran, hyperbolic functions, Trigonometric functions, UDF, VBA
2 Comments
Trigonometric Functions in VBA – Update
In this post from February a set of VBA trigonometric functions were presented, using the derivations given on the Microsoft Developer Network site: Derived Math Functions Unfortunately two of the functions were wrong; the correct versions are shown below: Inverse Secant … Continue reading
Linking Excel to Fortran – 2
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 Cubic, Excel, Fortran, Quadratic, UDF, VBA
23 Comments
Linking Excel to Fortran
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
Silverfrost Personal Fortran
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
Newton Excel Bach, not (just) an Excel Blog 