Bentley Communities
Site
Search
User
Site
Search
User
Product Communities
Building
OpenBuildings | AECOsim | Speedikon
Cancel
OpenBuildings | AECOsim | Speedikon
OpenBuildings | AECOsim | Speedikon Wiki
Steps needed to create a Structural Report Spreadsheet
Building Design - Wiki
+
OpenBuildings Designer
+
OpenBuildings Energy Simulator
+
GenerativeComponents
OpenBuildings Station Designer
+
OpenBuildings Speedikon
+
OpenBuildings Speedikon + Bentley Speedikon V8i
+
Bentley Facilities Space Planner CONNECT Edition
-
AECOsim Building Designer
+
Annotation - AECOsim Building Designer
+
Architectural Design - AECOsim Building Designer
+
ASM (Analytical Space Model)
+
Configuration - AECOsim Building Designer
+
DataGroup System - AECOsim Building Designer
+
Dataset and Content - AECOsim Building Designer
+
Drawing Extraction - AECOsim Building Designer
+
Drawing Views - AECOsim Building Designer
+
Electrical Annotation and Design - AECOsim Building Designer
+
Floors - AECOsim Building Designer
+
Form Modeling - AECOsim Building Designer
+
General - AECOsim Building Designer
+
Grid Systems - AECOsim Building Designer
+
HVAC Design - AECOsim Building Designer
+
i-model - AECOsim Building Designer
-
Import/Export - AECOsim Building Designer
'Runtime error 9' Creating Structural Report Spreadsheet
Cadworx object enabler for AECOsim Building Designer
Can MicroStation solids be included when generating ISM files?
CONNECT Edition - Modify CIS/2 File in AECOSim Building Designer
Export 2D to 3D or 3D to 2D for multiple files
Export Selected Elements to DWG
Export to ISM of a File with multiple References
Exporting to Step Format
Horizontal Braces import from STAAD.Pro as Beams
How to show area and volume in the schedule after attaching instance data to MicroStation element
+
IFC - Import/Export - AECOsim Building Designer
Importing STAAD.Pro files with correct placement point orientation
Integration with external Mechanical & Electrical applications
List Type ID instead of Mark in Structural Report Spreadsheet
MagiCAD object enabler for AECOsim Building Designer
Methods to import ABD files into Revit
+
Other - Import/Export - AECOsim Building Designer
Sketchup Files Will Not Open or Display
Steps needed to create a Structural Report Spreadsheet
STP File Exported From SAP 2000 is Empty
Structural export options in AECOsim Building Designer SELECTseries6
Version Error in ISM import/Structural Synchronizer
When a DGN file is exported to DWG the colors change
+
Installation - AECOsim Building Designer
+
Modify - AECOsim Building Designer
+
Platform Tools - AECOsim Building Designer
+
Plumbing Design - AECOsim Building Designer
+
Print/Plot - AECOsim Building Designer
+
ProjectWise Integration - AECOsim Building Designer
+
Settings/Attributes - AECOsim Building Designer
+
Space Planner - AECOsim Building Designer
+
Structural Design - AECOsim Building Designer
+
Utilities - AECOsim Building Designer
+
Workspace - AECOsim Building Designer
+
iModel Plugin for Revit
+
Social Distance Assessments
Working from home with OpenBuildings products
+
Special Interest Group (SIG) FAQs
+
Structural Modeler_PS
+
Configuration Explorer
+
Legacy Products
Learning Content for OpenBuildings Designer
You are currently reviewing an older revision of this page.
History
View current version
Steps needed to create a Structural Report Spreadsheet
Applies To
Product(s):
AECOsim Building Designer
Version(s):
08.11.09.747
Environment:
N\A
Area:
Structural Design
Subarea:
N\A
Original Author:
Robert DiMauro, Bentley Technical Support Group
Steps to Accomplish
From the Data tab of the Building Designer Tasks, select "Structural Report Spreadsheet". This should immediatley open Excel.
If not, you do not have an "Add-Ins" tab at the top of the Excel menu, you need to "Enable all Macros" from the Macro Settings.
1.Select File > Options > Trust Center. Then select the Trust Center button.
2.Click "Macro Settings".
3.Click the options that you want:
Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. This setting makes your computer vulnerable to potentially malicious code and is not recommended.
Trust access to the VBA project object model This setting is for developers and is used to deliberately lock out or allow programmatic access to the VBA object model from any Automation client. In other words, it provides a security option for code that is written to automate an Office program and programmatically manipulate the Microsoft Visual Basic for Applications (VBA) environment and object model. This is a per user and per application setting, and denies access by default. This security option makes it more difficult for unauthorized programs to build "self-replicating" code that can harm end-user systems. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. To turn on access, select the check box.
4. Click ok and exit Excel. Restart the Structural Report Spreadsheet and you will now have an Add-Ins tab.
5. Click on it and select "Structural Quantity Report>Begin Quantity Report.
6. Excel should start to populate with all the structural members.