Category Archives: Link to dll

Compiled Matrix Functions for Excel

Posted on 12/11/2012 by dougaj4

This is a follow on from the previous post, showing how the C# version of the ALGLIB maths library can be accessed from Excel, with very little additional coding.  The download file, Matrixdll-c#.zip includes compiled .dll and .tlb files which can be used … Continue reading →

Posted in AlgLib, Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , , | 4 Comments

Links to link VBA to C#

Posted on 03/11/2012 by dougaj4

If you search the Internet for information on how to link Excel VBA to C# you will find thousands, if not millions, of links with details of how to connect to Excel from C#, but very few about going the … Continue reading →

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

Daily Download 31: Linking to Fortran

Posted on 18/10/2012 by dougaj4

Several routines linking to Fortran dll files, produced with the Silverfrost Fortran compiler, have been provided in previous daily downloads.  Today’s files are example routines, provided with posts covering the procedures to link Excel to Fortran code.  Note that these files … Continue reading →

Posted in Computing - general, Excel, Fortran, Link to dll, UDFs, VBA | Tagged , , , , , | Leave a comment

Daily Download 29: Using VBA – linking to C

Posted on 16/10/2012 by dougaj4

The final few days of the daily download series will be dealing with the use of VBA, starting with linking to C (and C++).  This was covered in: Linking Excel to C Linking Excel to C – 2 Linking Excel … Continue reading →

Posted in Computing - general, Excel, Link to dll, UDFs, VBA | Tagged , , , , | Leave a comment

Daily Download 23: Trigonometric Functions in VBA and Fortran

Posted on 09/10/2012 by dougaj4

The trigonometric functions provided in Excel omit some functions, and the functions provided in VBA are still more restricted.  Notably VBA does not provide an ATan2 function, which is required to define an angle over a full 360 degree range, based on X, … Continue reading →

Posted in Coordinate Geometry, Excel, Link to dll, Maths, Newton, UDFs, VBA | Tagged , , , , , | 8 Comments