Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- 3DFrame - 3D Frame analysis for Excel
- Beam actions and deflections by Macaulay's Method
- About Newton Excel Bach
- Using Linest for non-linear curve fitting, examples, hints and warnings
Recent Comments
Tag Archives: dll
Installing dlls on 64 bit Windows
Several of the spreadsheets available here include routines linking to compiled code written in C#, C++ or Fortran, which require the installation and registration of dll files. The procedures for doing this are significantly different on machines with 64 bit … Continue reading
Posted in Computing - general, Excel, Link to dll, VBA
Tagged 64 bit Windows, dll, link to dll, VBA
10 Comments
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
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 AlgLib, C++, dll, Excel, Matrix Functions, UDF, VBA
18 Comments
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 AlgLib, C++, dll, eigen value, Excel, matrix inversion, UDF, VBA
4 Comments
Distributing Silverfrost Fortran Applications
Earlier posts have included User Defined Functions (UDFs) linked to Fortran dll files compiled with Silverfrost Personal Fortran: Solving simultaneous equations – Fortran dll Trigonometric Functions – dll Linking Excel to Fortran – 2 Transferring these files to a new computer it came to my … Continue reading
Posted in Excel, Link to dll, UDFs, VBA
Tagged dll, Excel, Fortran, Silverfrost, UDF, VBA
2 Comments