Autodesk Robot Structural Analysis

[#1]

Hi all,

I was trying to adapt some macros that some users gently post here on Discussion Groups.

I already made a part of what i wanted...but this is the first time i'm trying to use macros, so i'm not being able to do the rest.

I have already a way to have all forces on my xls file, but i want to get in the following columns Lenght(m) | Section | Rect_BF | Rect_HT | Rect_EP | Bar Name | Deflection (mm)

How can i do this? Can you help me?

Thanks, please see attachement

[#2]

Example code:

The sectional data \ interface \ access depends of section type: from database or user or tappered or complex ....

What sections do you have?

Dim RobApp As New RobotApplication
Dim Bar As IRobotBar
Dim Sel As IRobotSelection
Dim Sec As RobotBarSection
Dim BarCol As RobotBarCollection
Dim sectData As IRobotBarSectionData



Set Sel = RobApp.Project.Structure.Selections.Get(I_OT_BAR)
Set BarCol = RobApp.Project.Structure.Bars.GetMany(Sel)

For i = 1 To BarCol.Count
    
    Set Bar = BarCol.Get(i)
    Set sectLab = Bar.GetLabel(I_LT_BAR_SECTION)
    Set sectData = sectLab.Data

    Set Sec = Bar.GetLabel(I_LT_BAR_SECTION)


    Cells((7 + i), 1) = Bar.Number
    Cells((7 + i), 2) = Bar.Length
    Cells((7 + i), 3) = Sec.Name
    Cells((7 + i), 4) = sectData.GetValue(I_BSDV_AX) ' A of section
    Cells((7 + i), 5) = sectData.GetValue(I_BSDV_D) ' h of section
 
Next i

Exit Sub

[#3]

I have regular Rc Beams and Rc Columns.

I tried to copy that code to "my" macros but it simply not work...where should i paste that?

Thanks in advance

[#4]

I have regular Rc Beams and Rc Columns.

OK , I will show you.

I tried to copy that code to "my" macros but it simply not work...where should i paste that?

It was example for steel sections - copy it to separate xls file

[#5]

OK , I will show you.

Thanks Rafal, if you don't mind please check the attachement on my first post.

[#6 · Accepted solution]

Take a look at attached xls

[#7]

Dear Rafal, i don't know how to thank you!
Thank you so much!

Greetings from Portugal!

1000 kudos for you!

[#8]

Hi Rafal,

I'm seeing that this macro is for 2 or more points in a bar.

What should i do to extract data only for 1 point? 

For example:

I want data (forces, section propreties, etc...) for the point x=0 of the bar.

Thanks in advance,

Cheers!

[#9]

hi.

File excel erro ???????

[#10]

Where is the error?