Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenBuildings | AECOsim | speedikon | LEGION
  • Product Communities
  • Building
  • OpenBuildings | AECOsim | speedikon | LEGION
  • More
  • Cancel
OpenBuildings | AECOsim | speedikon | LEGION
OpenBuildings | AECOsim | speedikon | LEGION Wiki Steps needed to create a Structural Report Spreadsheet
    • Sign in
    • Building Design - Wiki
    • +OpenBuildings Designer
    • -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
        • Creating Custom Schedule Report
        • 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 PDMS data to 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
        • London Underground - TFL447
        • 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
      • +User Interface
      • +Utilities - AECOsim Building Designer
      • +Workspace - AECOsim Building Designer
    • +OpenBuildings Energy Simulator
    • +GenerativeComponents
    • +Bentley Facilities
    • +Bentley speedikon
    • +Bentley LEGION
    • +iModel Plugin for Revit Overview
    • +Special Interest Group (SIG) FAQs
    • CIS/2 Analysis Data
    • Managed Data Item
    • +Legacy Products
    • +Configuration Explorer

     
     Questions about this article, topic, or product? Click here. 

    Steps needed to create a Structural Report Spreadsheet

     
      Product(s): AECOsim Building Designer
      Version(s): 08.11.09.866
      Environment:  N\A
      Area:  Import/Export
      Subarea: 
     

    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.

    • structural design
    • AECOsim
    • 08.11.09.747
    • AECOsim Building Designer
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Robert DiMauro Created by Robert DiMauro
    • When: Thu, Jul 24 2014 12:57 PM
    • Robert DiMauro Last revision by Robert DiMauro
    • When: Tue, Feb 13 2018 1:10 PM
    • Revisions: 10
    • Comments: 0
    Anonymous
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • User Management
    • Licensing Manager
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2019 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies