This article shows how to create a tool to display a parts list for members, cross-sections, and materials from RFEM. The programming environment is VBA in Excel.
The parts list for the members, cross-sections, and materials is displayed in the spreadsheets "Parts List", "Parts List by Cross-Section", and "Materials List" after clicking on the [Parts List] or [Materials List] button. It is necessary for the corresponding RFEM file to be open already.
Inserting Reference
The RFEM object libraries Dlubal RFEM Type Library v3.4 and Dlubal RFEM Type Library v5.5, as well as Microsoft Scripting Runtime, have to be integrated in the VBA editor first, by clicking "Tools" → "References". The Dlubal RFEM Type Library v3.4 object library is necessary to get the cross-section values.
Source Code
The Excel file with the source code for creating a parts list can be downloaded under "Downloads" at the bottom of this article. The individual steps are explained in the comments.
Summary and Outlook
In this article, a tool was developed to display a parts list from RFEM. It is also possible to create a corresponding tool in RSTAB.
The tool is started in Excel. There is also the option to include it in the RFEM or RSTAB interface. This is described in the linked article.