COM Interface in VBA | Creating a Parts List
Parts lists give information about which and how many parts are necessary for creating a building. They are the basis for identifying the needs and purchasing the components. Parts lists can be created in the design modules such as RF-/STEEL EC3, RF-/TIMBER Pro and so on. Additionally, a customized parts list can be created with the RF-COM/RS-COM interface.
This article shows creating 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 that the corresponding RFEM file is already opened.
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 object library Dlubal RFEM Type Library v3.4 is necessary to get the cross-section values.
The Excel file with the source code for creating a parts list can be downloaded under Downloads at the bottom of this article. The single 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. It is also an option to include it into the RFEM or RSTAB interface. This is described in the linked article.
Sonja von Bloh, M.Sc.
Product Engineering & Customer Support
Ms. von Bloh provides technical support for our customer and is responsible for the development of the SHAPE‑THIN program.
Do you have questions or need advice?
Contact our free e-mail, chat, or forum support or find various suggested solutions and useful tips on our FAQ page.
For some structures, it is necessary to design them in different configurations.
- Reading and writing access to structural data, load case data, load and result combinations, and calculation results
- External control of calculation
- Possibility to open and edit available models or to create new models
- Access to all results such as deformations, internal forces, and support reactions
- Ability to intercept possible errors using error messages
- Access to control elements as well as results of the following programs:
- RF-/STEEL EC3
- RX-TIMBER Glued-Laminated Beam
- RF-/TIMBER Pro
- RF-/DYNAM Pro
- Can I define nonlinear support conditions via the COM interface?
- Can I use RFEM to calculate a log house three-dimensionally?
- Which programs can I use to calculate and design power plants?
- I am trying to import a model from cadwork. Unfortunately, I cannot correctly transfer the cross-sections from cadwork to RFEM. Do you have any tip?
- When importing a model directly from AutoCAD, the shape of the "spline" is sometimes incorrect.
- How to model a cable net structure in using the RF-FORM-FINDING add-on module?
- I would like to export the reinforcement of a slab in the Nemetschek format. However, no setting is available in the following window after selecting the surface.
- Does RFEM integrate with Autodesk Inventor?
- How can I import an IFC model into the RWIND Simulation environment?
- How can I create member eccentricities in RS‑COM?
Structural engineering software for finite element analysis (FEA) of planar and spatial structural systems consisting of plates, walls, shells, members (beams), solids and contact elements
Programmable interface (API) based on the COM technology