Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Time in hours and minutes between two dates
- Downloads by category
- Taming Symbols in Excel
- Drawing in Excel 7 - Creating drawings from coordinates
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Sophea CE on Biaxial bending update Python optional argu… on Using Python optional argument… Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update Units4Excel Update |… on Extracting text from an Intern… dougaj4 on Using LinEst() on data with… More on RC design of… on Reinforced Concrete Design for… AndyF83 on Using LinEst() on data with… dougaj4 on Extracting text from an Intern… Kirby on Extracting text from an Intern… Extracting text from… on Evaluating text with units and… dougaj4 on Deflections and Moments in Rec…
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