STAAD.Pro interaction with excel spreadsheet (extracting Beam End Forces from STAAD.Pro to Excel cell dropdown cell)

I am not sure if I fully understood the question but you can filter any table from within the STAAD.Pro Post processing mode ( Utilization table or the Beam End Forces table ) based on certain members or groups. You may take your mouse cursor anywhere within the table and right click to chose Results Setup and you can choose the appropriate group from within the Range tab. The table results will then get filtered based on your selection. Subsequently you can select the table data from STAAD.Pro, copy it and paste it into Excel. 

I didn't want to copy each group results from STAAD.Pro and then copy the same in excel.
I would try to elaborate the query below:

I have all the defined groups in Excel dropdown list which are already defined as groups in STAAD.Pro.

I wanted to make it dynamic ( which links excel from STAAD.Pro).

Lets say if I select Group1 from dropdown list in excel, then it should display corresponding group1 results in excel.

And if I select group2 in dropdown list in excel, it should automatically update group 2 results (Beam End forces) in excel.

Without going to STAAD.Pro everytime to copy the results, can it directly extract the results from excel.

I wish I could explain my query now.

The code is only intended as a guide for how you can obtain the data of members defined in groups in a STAAD.Pro model. Clearly it requires you to implement it in a complete Excel Macro that creates an OpenSTAAD object and you carry out the required housekeeping. Have you done that?  If you think there is a problem with your installation of OpenSTAAD then I would suggest you register a service ticket to determine why the code does not work for you.

Here is a spreadsheet that uses the above code to display the details of member groups on a spreadsheet. Putting the information into drop lists in Excel and grabbing other member data is work you would need to carry out.  

OpenSTAAD.xlsm

Dear Carlos Aguera,

Thank you for taking time and replying.

I would trouble you by asking my prime question that how to extract Beam End Forces Summary in the spreadsheet of any particular group selected in a dropdown menu.

I followed your instructions and the sheet works great.

Can you mention the code to extract Beam End Forces summary from STAAD please,

Wish you a great day ahead.

Beam End forces Summary for Envelope Case or series of Load Combinations for a particular Group would help

You should refer to the OpenSTAAD documentation which lists all the available functions and methods amny of which include sample code such as the function I believe you are looking for which is:-

This would need to be called in a loop for each member and each load case/combination that you were interested in. The results of all the degrees of freedom are held in the array pdForces. You can then determine what you want to do this data in your spreadsheet. 

My understanding of OpenSTAAD is very limited,

However thank you for reply.

Let me see how I can do my tasks done in simpler way. Have a pleasant day Carlos Aguera.

My understanding of OpenSTAAD is very limited,

However thank you for reply.

Let me see how I can do my tasks done in simpler way. Have a pleasant day Carlos Aguera.