Tag Archives: VBA

Trigonometric Functions in VBA – Update

Posted on 06/12/2008 by dougaj4

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 →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , | 5 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

Drawing in Excel 7 – Creating drawings from coordinates

Posted on 11/11/2008 by dougaj4

Previous Post, Drawing in Excel 6 The file PlotXYcontains routines to plot scale drawings in Excel from a list of XY coordinates of node points, node points for each shape, and formatting details for each shape type.  The plot is scaled … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , | 25 Comments