This wiki demonstrates an Excel macro created with RAM DataAccess, the programming interface into RAM Structural System model data that comes with regular product installation. At the link below is an Excel file containing a macro that automates the creation of lateral-resisting frames in RAM Structural System:

https://communities.bentley.com/products/ram-staad/m/structural_analysis_and_design_gallery/274513

A great resource for getting started with RAM DataAccess:

https://communities.bentley.com/products/ram-staad/m/structural_analysis_and_design_gallery/141899