Getting internal forces from RSA to Excel (API)

[fmp999]

Dear members,

I would like to know if someone can share a excel sheet (VBA) to extracte the internal forces from all the bars of my structure. I just need the maximum internal force in the bar, not the values at the bottom or top of the bar (extremes nodes of the bar).

The internal forces that i need are: N, My,Mz;Vy;Vz (i dont need torsion).

I also want to have the possibility to choose all (or just one) the loads cases that i previously had defined in my structural model.

Thank you and regards,

fmp

[Rafal.Gaweda]

Have you checked the forum ?

[fmp999]

Yes, I have found many excel sheets, but none of them had all the the internal forces that i need (N,My,Mz;Vy;Vz) and also i don't know if there are new updated excel sheets (possible minor bugs corrected).

[fmp999]

I have found a excel sheet that almost does what i want, the only problem is that some internal forces are missing, in this case i need N,My,Mz;Vy,Vz.

[Rafal.Gaweda · Accepted solution]

Try this

[duchoabn]

Dear RG_Adsk

I want create model in RSAP from excel

And Get Result In RSAP to Excel 

please guide me how to do?
Does not need to learn VBA? or C #?

Thanks

[Rafal.Gaweda]

I want create model in RSAP from excel

And Get Result In RSAP to Excel 

please guide me how to do?
Does not need to learn VBA? or C #?

If you want to use Excel - use Excel VBA.

[duchoabn]

Yes Thaks you

I'd love to use VBA for this work

Modeling in RSAP from excel use VBA

Please guide for me

Thanks