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:

Original Author:

Robert DiMauro