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.
Please follow the following video for the workflow for an alternate solution: