Hi
For those who might be interested I am attaching xls file with macro for objects geometry modifications.
One button to import geometry (characteriscic points coordinates) of selected objects (lines, polylines, arc, circles, panels), second - to update their geometry basing on data in Excell.
NOTE: modify only cells with coordinates.
Solved! Go to Solution.
Solved by Rafal.Gaweda. Go to Solution.
Thank Rafal!
But I didn't understand in which cell I can change the thickness!
Column C if you are using objects_geometry_with_rounding_5.xlsm
OK, but what if...I want to have my own thickness and instead of creating it in a software I put it in an excel. Is it possible to load that thickness(defined in an excel sheet) to the software whether I always must create corresponding one in the software?
Hi @Rafal.Gaweda is it possible to get dimensions from a bar? I 'm missing that code!
Can you help me please?
Thank you so much!
Hi @m.ridi220
My understanding is : Bar dimension = bar length
Bar length is calculated as distance between bar start node and endnode.
If you want to change bar length you have to move node(s).
See this addin.
My bad @Rafal.Gaweda, for dimensions I mean B (base) and H (height) of the concrete section
My bad @Rafal.Gaweda, for dimensions I mean B (base) and H (height) of the concrete section
Do you mean RC cross section dimensions?
Example here.
@Rafal.Gaweda Importing into excel both dimensions B and H from a RC section in Robot
Hi @m.ridi220
Importing into excel both dimensions B and H from a RC section in Robot
Look at the example I pointed you.
Instead of ...SetValue use ...GetValue
What a long-standing forum! The add-in has clearly withstood the test of time...
Anyways, you can see in the screenshot that only 5 of hte nodes updated. This is because I added two intermediate points in the definition of hte panel, and I suspect the add-in doesn't support the addition of points -- it will only update the existing points.
Can you confirm I understand that correctly, or if there is in fact a way to add intermediate points to the definition of a panel with this add-in?
Thanks
Hi @mike.kovacs
I suspect the add-in doesn't support the addition of points -- it will only update the existing points.
Exactly.
Thanks Rafal. IF I was better at programming, I'd add that feature. I was easily able to copy the coordinates in the Excel table, into the Robot coordinates table for the definition of this panel -- so it wasn't hopeless.
Hi @Rafal.Gaweda I did:
Set RLabel = RobApp.Project.Structure.Labels.Create(I_LT_BAR_SECTION, LabelName) Set RBSD = RLabel.Data RBSD.ShapeType = I_BSST_CONCR_BEAM Set RBSCRD = RBSD.Concrete RBSCRD.GetValue I_BSCDV_BEAM_B, (Cells(Row, 10).Value)
but i get the following error:
"Wrong number of arguments or invalid property assignment"
Hi @m.ridi220
My understanding is you want to GET it so example below:
Dim RLabel As RobotLabel Dim RBSD As RobotBarSectionData Dim RBSCRD As RobotBarSectionConcreteData Set RLabel = RobApp.Project.Structure.Labels.Get(I_LT_BAR_SECTION, "B 30x50") Set RBSD = RLabel.Data Set RBSCRD = RBSD.Concrete Cells(1, 10) = RBSCRD.GetValue(I_BSCDV_BEAM_B)
My bad @Rafal.Gaweda, what I mean is to get for a generic beam both base and height dimensions from robot into excel.
In your example I think is for a specific beam "B 30x50"