'Runtime error 9' Creating Structural Report Spreadsheet

 Product(s):AECOsim Building Designer
 Area:Structural Design


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.


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:

 Original Author:Robert DiMauro