script VBA EXCEL (Lx and Ly of structure)

[b_hadjiT66B8]

I have a question, how I can find the Lx and Ly of structure (width and length of the structure)

I need script VBA EXCEL

 OR the name of width and length in VBA EXCEL.

Thanks for your hel

p.

[Romanich · Accepted solution]

Hi @b_hadjiT66B8 

 Dim RStorey As RobotStorey
 Dim RStoreyValues As RobotStoreyValues
 Dim AllStories As RobotStoreyMngr
 Set AllStories = RobApp.Project.Structure.Storeys
Set RStorey = AllStories.Get(ii)
Set RStoreyValues = RobApp.Project.Structure.Results.Storeys.Values(ii, ModalCase)

Sheet1.Cells(Row, 7) = RStorey.LX
Sheet1.Cells(Row, 8) = RStorey.Ly

[b_hadjiT66B8]

Thank you Romanich it is work.

[b_hadjiT66B8]

Thank you Romanich it is work.