Category Archives: Link to dll

Xll add-ins; are they worth the trouble?

Posted on 11/06/2010 by dougaj4

As regular readers will know, I occasionally delve into compiling code in C++, or even Fortran, as dlls and link to them with a short piece of VBA to communicate between the spreadsheet and the compiled code.  I have also … Continue reading →

Posted in Excel, Link to dll | Tagged , , , | 8 Comments

Compiled AlgLib Matrix Functions for Excel

Posted on 27/05/2010 by dougaj4

This post describes a series of matrix functions compiled from the AlgLib library code (covered in previous posts) as a dll that can be called from Excel VBA, and used as User Defined Functions (UDFs).  A spreadsheet containing the necessary VBA … Continue reading →

Posted in Arrays, Excel, Link to dll, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 18 Comments

Linking AlgLib C++ to Excel VBA

Posted on 22/05/2010 by dougaj4

The previous post described how to install AlgLib VBA routines in Excel.  It is also possible to make AlgLib c++ routines (compiled as dll’s) available from Excel, either from VBA, or using User Defined Functions (UDFs) directly from the spreadsheet.  Using compiled dll … Continue reading →

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

Distributing Silverfrost Fortran Applications

Posted on 28/12/2009 by dougaj4

Earlier posts have included User Defined Functions (UDFs) linked to Fortran dll files compiled with Silverfrost Personal Fortran: Solving simultaneous equations – Fortran dll Trigonometric Functions – dll Linking Excel to Fortran – 2 Transferring these files to a new computer it came to my … Continue reading →

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

Solving simultaneous equations – Fortran dll

Posted on 20/12/2008 by dougaj4

The file simultaneous.zip has been modified to allow access to a Fortran simultaneous equation routine, compiled as a dll.  The original file was posted in solving simultaneous equations.  The advantages of a compiled routine include: Much better performance Greater precision through … Continue reading →

Posted in Arrays, Fortran, Link to dll, Maths, UDFs, VBA | Tagged , , , , , | 3 Comments