Category Archives: Link to dll

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 , | 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 , , , , , , | 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

Posted in Excel, Link to dll, VBA | Tagged , , , | Leave a comment

Frame analysis with spring releases; 2D

I have updated the Frame4 spreadsheet to allow a rotational spring stiffness to be specified for members with a rotational end release.  The new file can be downloaded from: Frame4.zip See Installing C# dll files, reminder for details of installing the … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7, VBA | Tagged , , , , | 1 Comment

Installing C# dll files, reminder

Installing the Frame4 spreadsheet on a new computer I had some problems registering the dll files required for the compiled solver routines, so here is a reminder of the procedure: Copy the alglibnet2.dll and ALMatrixLib.dll files to the appropriate folder (see … Continue reading

Posted in Excel, Frame Analysis, Link to dll, VBA | Tagged , , | 5 Comments