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
- Using Goal Seek on Multiple Cells
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Contour plots with Excel and Matplotlib
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads by category
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…
Category Archives: Link to dll
Removing Add-ins
Recently I had problems with an Excel Add-in that was still trying to run, and generating error messages, even after being removed from the add-in list and uninstalled. After much searching and trying suggested methods that didn’t work, I finally … Continue reading
Posted in Computing - general, Excel, Link to dll, Link to Python, VBA
Tagged Add-in problems, Excel, Link to Python, Regedit, Remove add-ins, VBA, Windows registry
Leave a comment
Using Excel with Python and ctypes
The Strand7 API provides an interface between the Strand7 Finite Element Analysis program and external software. It works with many different languages, including Python, which uses ctypes to transfer data to and from the API functions. It is essential that … Continue reading
Posted in Beam Bending, Excel, Link to dll, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged ctypes, Excel, Python, PyXLL, Strand7 API, UDF
Leave a comment
64 bit Excel and the Strand7 API
Back in May 2017 I posted a sample spreadsheet using the Strand7 API to allow Excel to read and write Strand7 node data and results. A comment noted at the time that the spreadsheet was not working with 64 bit … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7
Tagged 64 bit Excel, Strand7 API
Leave a comment
Installing Frame4 and 3DFrame
Following a recent comment I have added a VBA only version to the download files of the frame analysis spreadsheets: 3DFrame.zip Frame4.zip The VBA versions should work on any version of Excel from 2007, with macros enabled, without any further installation. The … Continue reading
Posted in AlgLib, Excel, Frame Analysis, Link to dll, Newton, VBA
Tagged 3D frame analysis, 3DFrame, Excel, Frame Analysis, Frame4, link to dll, VBA
Leave a comment
February Links
Two new links with valuable free resources: .net and office automation follies : including many advanced VBA resources. Thanks to Alfred Vachris for the link. AET VBE Tools : Tools for the Visual Basic editor from Andrew Engwirda (via Daily Dose of … Continue reading