Recent Comments
Category Archives: VBA
XLDennis, the MSDN Library, and VBA rant
Dennis Wallentin, aka XLDennis, is a long time contributor to the on-line Excel community and co-author of the latest version of Professional Excel Development. In recent years he has concentrated on the use of the VSTO and .NET products in … Continue reading
Posted in Computing - general, Excel, VBA
Tagged application development, Excel, VBA, VSTO
13 Comments
More on writing arrays to the worksheet
Writing a large VBA array to the worksheet in a single operation, rather than cell by cell, can result in a huge improvement of the speed of many macros. The basic technique was described here. I recently wanted to modify this … Continue reading
Using the Strand7 API
Strand7 is a general purpose Finite Element Analysis program, which has an Application Programming Interface (API), allowing external programs to interact with Strand7, including reading and writing to data files, running analyses, and reading the results. The API is a comprehensive … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged API, Excel, Finite Element Analysis, Strand7, UDF, VBA
7 Comments
Flipping Coin Problems
At Daily Dose of Excel Dick K. looks at a VBA solution to this problem: Problem description: Take a stack of coins all heads up. Upturn the topmost coin, place back on the stack and then proceed: take the top 2 … Continue reading
Using Beam Design Functions
“Beam Design Functions” is an Excel spreadsheet providing a User Defined Function (UDF) that will calculate the stresses, strains, forces and moments in a reinforced or prestressed concrete section subject to any specified bending moment and axial load, using an … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Beam Bending, elastic analysis, Excel, Prestressed concrete, Reinforced Concrete, Section Analysis, UDF, VBA
12 Comments
Newton Excel Bach, not (just) an Excel Blog 