Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenBuildings | AECOsim | Speedikon
  • Product Communities
  • Building
  • OpenBuildings | AECOsim | Speedikon
  • Cancel
OpenBuildings | AECOsim | Speedikon
OpenBuildings | AECOsim | Speedikon Wiki 'Runtime error 9' Creating 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
    • Working from home with Speedikon
    • +Special Interest Group (SIG) FAQs
    • +Structural Modeler_PS
    • +Configuration Explorer
    • +Legacy Products
    • Learning Content for OpenBuildings Designer

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

    'Runtime error 9' Creating Structural Report Spreadsheet

      Product(s): AECOsim Building Designer
      Version(s): 08.11.09.829
      Environment: N\A
      Area: Structural Design
      Subarea: N\A

    Problem

    When creating a Structural Report Spreadsheet using Office 365 Business, a runtime error '9' Subscript out of range error is received when Excel opens.  All other VBA tools in AECOsim are working properly.

    Solution

    The line of code that is causing the error in the Microsoft Excel VBA, when opened in Visual Basic Editor, is “name = Application.CommandBars(1).Controls.Item(10).Caption”
    If you edit the line of code to “name = Application.CommandBars(2).Controls.Item(1).Caption”, the problem is fixed.

    Alternate Solution

    Please follow the following video for the workflow for an alternate solution:

    Play this video



      Original Author: Robert DiMauro
    • structural design
    • 08.11.09.829
    • AECOsim
    • en
    • AECOsim Building Designer
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Robert DiMauro Created by Robert DiMauro
    • When: Wed, Dec 16 2015 8:38 AM
    • Steve Cocchi Last revision by Bentley Colleague Communities MVP Steve Cocchi
    • When: Tue, Feb 13 2018 4:37 PM
    • Revisions: 4
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

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