Excel and STAAD Integration problem

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.


Ankit Gupta

Parents Reply Children
No Data