Recent Comments
Author Archives: dougaj4
Using Regasm.exe
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 C++, Excel, linking to c++, regasm, UDF, VBA
7 Comments
Compiled Matrix Functions for Excel
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 AlgLib, C++, Eigen values, eigen vectors, Excel, linear equations solver, matrix determinant, Matrix Functions, matrix inverse, sparse solver, UDF, VBA
4 Comments
Links to link VBA to C#
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
More moves through the fair
Following the last Bach instalment, here are three more versions of She Moves Through the Fair. The first is the “official” Fairport Convention release, with Sandy Denny on vocals. Much more polished than the demo version posted last time, but … Continue reading
Posted in Bach
Tagged Bert Jansch, Davy Graham, Eric Clapton, Fairport Convention, Richard Thompson, Sandy Denny, She Moves Through the Fair
3 Comments
Polynomial Update
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 Cubic, Evaluate polynomial, Excel, Jenkins-Traub, Quartic, Solve polynomial, UDF, VBA
12 Comments
