Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Commenting a block of code in VBA
- Downloads
- Drawing in Excel 7 - Creating drawings from coordinates
- Downloads by category
- Using Goal Seek on Multiple Cells
- Retrieving unique values from a range or array ...
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Benata on Ana Vidović mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd…
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