I am looking to create a Microsoft Excel Spreadsheet that pulls reactions out of RAM Frame using DataAccess and Visual Basic for Applications (VBA). Is there a sample VBA project or other guidance anywhere in the forums with code to read the lateral reactions (Major and Minor axis - shear, moment, and axial loads) for each load combination for a beam, a column, and a wall? With that, I would be able to manipulate this information within VBA as needed.
I am kind of new to programming with DataAccess and the 451 page Developer's Guide is a lot to wrap my head around. Any other resources/spreadsheets for DataAccess that anyone could suggest would also be greatly appreciated. Thank you!
Answer Verified By: Tom Curry
I've tried to build a excel spreadsheet to extract member force from analysed RAM SS model and found your code. But I get an error in IForces.GetLatBeamForcesLeftAt with the notification as image below. Do you have any idea about this? Thanks a lot.