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!
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 @Anonymous
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 @Anonymous
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 @Anonymous
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"
Can't find what you're looking for? Ask the community or share your knowledge.