Tag Archives: C++

Linking AlgLib C++ to Excel VBA

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

Linking Excel to C – 3; Avoiding bottlenecks

The previous post in this series included a C dll to solve cubic polynomial equations that could be called from VBA.  The performance of this routine is compared with a VBA routine using a similar algorithm in the sceenshot below (rows … Continue reading

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

Linking Excel to C – 2

In the previous post I decribed how to create four simple functions in Visual C++, and how to link them to an Excel spreadsheet or a VBA User Defined Function (UDF). This post will cover: Accessing arrays created in C++ functions … Continue reading

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

Linking Excel to C

One of the reasons often given for preferring programs like Matlab to Excel for scientific and engineering uses is the large body of specialist mathematical and scientific applications available to these programs.  In this and following posts I will describe how … Continue reading

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