Tag Archives: C++

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 , , , , , | 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 , , , , , , , , , , , | 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

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

Daily Download 29: Using VBA – linking to C

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

Excel, ALGLIB, C# and ExcelDNA

Having just responded to a comment, saying I would be focussing on Add-in Express, rather than ExcelDNA, I have just found a blog post about using the ALGLIB C# routines in Excel, with the aid of ExcelDNA: Parcell’s Posts; Tutorial: … Continue reading

Posted in Excel, Link to dll, Maths, VBA | Tagged , , , | Leave a comment

Xll add-ins; are they worth the trouble?

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

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 , , , , , , | 17 Comments