Category Archives: VBA

Spreadsheet Solutions For Structural Engineering

Posted on 07/10/2011 by dougaj4

Another site where the tasks considered suitable for programming in Excel and VBA are anything but “boring and repetitive” is Yakpol’s Spreadsheet Solutions For Structural Engineering: “This web site contains a collection of engineering spreadsheets for structural analysis and design of concrete and … Continue reading →

Posted in Beam Bending, Excel, Newton, VBA | Tagged , , , | 2 Comments

More on VBA

Posted on 06/10/2011 by dougaj4

Andy Pope posted the two links below in a comment to my previous post: A while back they added a VBA developer center to the msdn Office site. http://msdn.microsoft.com/en-gb/office/ff688774.aspx And this article on the Excel developer road map is interesting. … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , , , , , , , | Leave a comment

XLDennis, the MSDN Library, and VBA rant

Posted on 04/10/2011 by dougaj4

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

More on writing arrays to the worksheet

Posted on 28/09/2011 by dougaj4

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 →

Posted in Arrays, Excel, VBA | Tagged , , | 3 Comments

Using the Strand7 API

Posted on 23/09/2011 by dougaj4

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