You are currently reviewing an older revision of this page.
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.