VBA Excel macro for any object geometry modifications (API)

[Rafal.Gaweda]

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.

[Anonymous]

Hello!

I tried your excel sheet, but it doesn´t recoginze that robot is open.

How should i use the macro?

/Per

[Rafal.Gaweda]

Hi

Go to VBA Editor (Alt+F11), go to References, unmark Robot Object Modeler, close References window by pressing OK, open it again, select  Robot Object Modeler ver. 12.0., press OK

[Anonymous]

I´ve tried your solution on the problem, but it still gives the same error message.

/Per

[Rafal.Gaweda]

Try: 

1. Run Excel as Administrator, run Robot as Administrator, then check macro

2. Check \ set UAC :

[Anonymous]

This gives the same error.

[Rafal.Gaweda]

I need to ckeck it on your computer

Please register this isseu as Service Request or give me your details in Private Message

[Rafal.Gaweda]

In such case unregister ALL ROBOTS you have installed on your computer by command: path_to_robot.exe / unregserver

eg:

"C:\Program Files\Autodesk\Autodesk Robot Structural Analysis Professional 2011\System\Exe\robot.EXE" /unRegServer

then 

register the one you want to use.

eg:

"C:\Program Files\Autodesk\Autodesk Robot Structural Analysis Professional 2012\System\Exe\robot.EXE" /RegServer

[Anonymous]

Hello,

I had the same problem which i managed to solve with the help of the structural support team:

http://forums.autodesk.com/t5/Autodesk-Robot-Structural/Robot-API-for-ARSA-2012-error-429/td-p/32153...

A colleague of mine recently upgraded from ARSA 2011 to 2012, and our excel VBA API was unable to recognise that 2012 was open.  I tried to deregister both and register 2012 (with administration rights) with the method described in this post, but it didn't work.

I remember last time this happened Structural Support and I worked through the registry looking for and deleting outdated ARSA 2011 entries... can you tell me what to look for, what to delete, and what to keep?

[Rafal.Gaweda]

JUst to link some threads .

Modified macro with rounding:

http://forums.autodesk.com/t5/Autodesk-Robot-Structural/Panel-contour-points-modification-API/td-p/3...

[Anonymous]

How do I do actually run the below command? Do i need to open a cmd prompt first, then rund the relevant commands? Do I run them with or without the quotations?

Thanks

---

@Anonymous_Adsk wrote:

In such case unregister ALL ROBOTS you have installed on your computer by command: path_to_robot.exe / unregserver

eg:

"C:\Program Files\Autodesk\Autodesk Robot Structural Analysis Professional 2011\System\Exe\robot.EXE" /unRegServer

then 

register the one you want to use.

eg:

"C:\Program Files\Autodesk\Autodesk Robot Structural Analysis Professional 2012\System\Exe\robot.EXE" /RegServer

---

[Rafal.Gaweda]

similar to message 6 in

http://forums.autodesk.com/t5/Autodesk-Robot-Structural/API-error/m-p/3518984/highlight/true#M5791

[Anonymous]

Thx for this macro but I can import only panel contors and if I select some bars to change the coardiantes , a meesage appera that I'm not sellecting any thing

[Rafal.Gaweda]

Bars do not have any coordinates so it is impossible to correct them.
You can correct nodes coordinates in Nodes table or using this addin : http://forums.autodesk.com/t5/Robot-Structural-Analysis/Rounding-up-coordinates-API/td-p/3430533/pag...

[Anonymous]

Hello,

With this addin we can only round up or down nodes coordinates, how can we modify them?

Thank you!

[Rafal.Gaweda]

Robot -> Nodes table

[Anonymous]

Thank you.

Thanks to you I have an addin for modifying panels. Is there any addin for nodes?or how to write it in API?

Saraneiya

[Rafal.Gaweda]

Example attached.

[mgaafar]

Hi Rafal, hope you are doing well.

I was working in a project in the USA and had to use imperial units. the model has many inclined walls which creates rounding errors at edges.

now when i use all the excel files with API similar to the one attached, it extracts the selected data into excel in SI unit although the model is created in imperial units.

how can i force the API to use the same units as the model? 

[Rafal.Gaweda]

API itself uses internal Robot units which are SI units.

If you want to use different units, for example get \ set "structure dimension" you have to check this unit and its coefficient (for \ from meters in this case) and use this coefficient (or 1/coeff) while playing with other units

Example code how to get structure dimension unit and coefficient

Private Sub CommandButton1_Click()


Dim Robot As New RobotApplication
Dim projPref As RobotProjectPreferences
Set projPref = Robot.Project.Preferences

Dim RU As RobotUnitData
Set RU = projPref.Units.Get(I_UT_STRUCTURE_DIMENSION)
Dim RUED As RobotUnitEditionData
Set RUED = projPref.Units.UnitEdition.Get(I_UMT_LENGTH, projPref.Units.UnitEdition.Find(I_UMT_LENGTH, RU.Name))

MsgBox RU.Name + "   " + Str(RUED.Coefficient)

End Sub

So RUED.Coefficient should be used as a multiplier while getting coordinates and 1/RUED.Coefficient while updating Robot model.