Excel and STAAD Integration problem

Question

Hello Everyone, 
 I am working in a Metro Rail infrastructure project at present. For a particular design problem, I have to run number of STAAD files and extract the result. 
 I want to simplify the process of running the STAAD and extracting the result from STAAD Pro. 
 How do I approach to this problem through VBA and OpenSTAAD ? I don't want to open STAAD each time, then pasting my STAAD input file in STAAD editor, and then run the file in STAAD, and then extract the relevant result. 
 In simple words, I want to create a macro in excel itself. This macro should bypass all the above mentioned processes i.e., Copying STAAD Input + Paste in STAAD Editor + Run file in STAAD Pro + Extract result from STAAD Pro + Paste it back to MS Excel + Sorting in MS Excel for relevant result. 
 Thanks in advance if someone can help me with this. 
 Best, 
 Ankit Gupta

Carlos Aguera · Answer

There is a good example in your STAAD.Pro installation of an Excel spreadsheet that has a buil in macro to extract the data from the model in STAAD.Pro. 
You can use Excel if you want to parametrically define your model data and use OpenSTAAD to create the data into STAAAD.Pro. You will need to define all the releveant data, including node coordinates, members, finite lements, material, section properties, load cases, loading, combinations and type of analysis, etc. 
You can then use another macro in Excel to launch the STAAD.Pro analysis with the OpenSTAAD function AnalyzeModel.

Mallesh N G · Answer

HI 
 I have created so many Excel macro files which extract result from staad pro 
 Visit my blog and download the excel sheets it will save your time and you will get clarity on the output result 
 Blog: https://structuralengtips.blogspot.in/ 
 
 Regards 
 Mallesh