COM Interface in VBA | Creating a Parts List

Technical Article on the Topic Structural Analysis Using Dlubal Software

  • Knowledge Base

Technical Article

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.

Image 01 - Creating a Parts List

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 object library Dlubal RFEM Type Library v3.4 is necessary to get the cross-section values.

Image 02 - Including Dlubal RFEM Type Libraries and Microsoft Scripting Runtime

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

Author

Sonja von Bloh, M.Sc.

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.

Keywords

Parts List Material VBA

Downloads

Links

Write Comment...

Write Comment...

  • Views 789x
  • Updated 1 June 2021

Contact us

Contact Dlubal

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.

+49 9673 9203 0

info@dlubal.com

Online Training | English

RFEM | Basics

Online Training 13 July 2021 9:00 AM - 1:00 PM CEST

Online Training | English

Eurocode 2 | Concrete structures according to DIN EN 1992-1-1

Online Training 29 July 2021 8:30 AM - 12:30 PM CEST

Online Training | English

RFEM | Structural dynamics and earthquake design according to EC 8

Online Training 11 August 2021 8:30 AM - 12:30 PM CEST

Online-Schulungen | English

RFEM for Students | USA

Online Training 11 August 2021 1:00 PM - 4:00 PM EDT

Online Training | English

Eurocode 3 | Steel structures according to DIN EN 1993-1-1

Online Training 25 August 2021 8:30 AM - 12:30 PM CEST

Online Training | English

Eurocode 5 | Timber structures according to DIN EN 1995-1-1

Online Training 23 September 2021 8:30 AM - 12:30 PM CEST

Glass Design with Dlubal Software

Glass Design with Dlubal Software

Webinar 8 June 2021 2:00 PM - 2:45 PM CEST

Blast Time History Analysis in RFEM

Blast Time History Analysis in RFEM

Webinar 13 May 2021 2:00 PM - 3:00 PM EDT

Timber Structures | Part 2: Design

Timber Beam and Surface Structures | Part 2: Design

Webinar 11 May 2021 2:00 PM - 3:00 PM CEST

Plate and Shell Buckling Utilizing Dlubal Software

Plate and Shell Buckling Utilizing Dlubal Software

Webinar 30 March 2021 2:00 PM - 2:45 PM CEST

CSA S16: 19 Steel design in RFEM

CSA S16:19 Steel Design in RFEM

Webinar 10 March 2021 2:00 PM - 3:00 PM EDT

The Most Common User Errors With RFEM and RSTAB

The Most Common User Errors With RFEM and RSTAB

Webinar 4 February 2021 2:00 PM - 3:00 PM BST

Member design according to ADM 2020 in RFEM

ADM 2020 Member Design in RFEM

Webinar 19 January 2021 2:00 PM - 3:00 PM EDT

Dlubal Info Day

Dlubal Info Day Online | 15 December 2020

Webinar 15 December 2020 9:00 AM - 4:00 PM BST

Stability Design in Steel Construction with RFEM and RSTAB

Stability Design in Steel Construction with RFEM and RSTAB

Webinar 1 December 2020 2:00 PM - 2:45 PM BST

FEM - Troubleshooting and Optimization in RFEM

FEA Troubleshooting and Optimization in RFEM

Webinar 11 November 2020 2:00 PM - 3:00 PM EDT

Soil-Structure Interaction in RFEM

Soil-Structure Interaction in RFEM

Webinar 27 October 2020 2:00 PM - 2:45 PM BST

NBC 2015 Modal Response Spectrum Analysis in RFEM

Webinar 30 September 2020 2:00 PM - 3:00 PM EDT

Documenting Results in the RFEM Printout Report

Documenting Results in the RFEM Printout Report

Webinar 25 August 2020 2:00 PM - 2:45 PM CEST

ACI 318-19 Concrete Design in RFEM

Webinar 20 August 2020 2:00 PM - 3:00 PM EDT

How to Be More Productive Using RFEM

How to Be More Productive Using RFEM

Webinar 7 July 2020 3:00 PM - 4:00 PM CEST

Introduction to Solid Modeling \n in RFEM

Introduction to Solid Modeling in RFEM

Webinar 30 June 2020 2:00 PM - 3:00 PM EDT

Modeling with Solids in RFEM

Modeling with Solids in RFEM

Webinar 9 June 2020 3:00 PM - 3:45 PM CEST

}
RFEM
RFEM 5.xx

Main Program

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

Price of First License
3,540.00 USD
RFEM
RF-COM 5.xx

Add-on Module

Programmable interface (API) based on the COM technology

Price of First License
580.00 USD