Tag Archives: Excel

Frame4; now with added Alglib

Posted on 16/11/2012 by dougaj4

Edit 29 Nov 2012: I have now added an xls version to the download zip file.  This also has a much smaller example model, which will solve quickly using the VBA solver, so will be more useable for anyone having … Continue reading →

Posted in AlgLib, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, UDFs, VBA | Tagged , , , , , | 24 Comments

Using Regasm.exe

Posted on 13/11/2012 by dougaj4

If you work through the process described in the previous post Visual Studio will create two files (ALMatrixLib.tlb and ALMatrixLib.dll) that will automatically be registered so that the Excel VBA routines will be able to use them.  On the other hand if … Continue reading →

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

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

Polynomial Update

Posted on 30/10/2012 by dougaj4

Following a comment here: Solving cubic and quartic equations with Excel the Quartic and CubicC User Defined Functions (UDFs) have been amended to fix a problem occurring with some combinations of coefficients. The updated spreadsheet (including full open source code) can be … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , | 12 Comments