topic Re: VBA Excel macro for any object geometry modifications in Robot Structural Analysis Forum

VBA Excel macro for any object geometry modifications (API)

Rafal.Gaweda — Tue, 06 Mar 2012 10:04:16 GMT

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.

Re: VBA Excel macro for any object geometry modifications

Anonymous — Wed, 12 Oct 2011 15:26:09 GMT

Hello!

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

How should i use the macro?

/Per

Re: VBA Excel macro for any object geometry modifications

Rafal.Gaweda — Thu, 13 Oct 2011 07:06:30 GMT

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

Re: VBA Excel macro for any object geometry modifications

Anonymous — Fri, 14 Oct 2011 07:05:42 GMT

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

/Per

Re: VBA Excel macro for any object geometry modifications

Rafal.Gaweda — Fri, 14 Oct 2011 07:49:35 GMT

Try:

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

2. Check \ set UAC :

Re: VBA Excel macro for any object geometry modifications

Anonymous — Fri, 14 Oct 2011 08:18:46 GMT

This gives the same error.

Re: VBA Excel macro for any object geometry modifications

Rafal.Gaweda — Fri, 14 Oct 2011 08:30:32 GMT

I need to ckeck it on your computer

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

Re: VBA Excel macro for any object geometry modifications

Rafal.Gaweda — Fri, 14 Oct 2011 11:15:47 GMT

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

eg:

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

Re: VBA Excel macro for any object geometry modifications

Anonymous — Mon, 13 Feb 2012 01:52:00 GMT

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/3215324/page/2

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?

Re: VBA Excel macro for any object geometry modifications

Rafal.Gaweda — Fri, 28 Sep 2012 07:46:12 GMT

JUst to link some threads .

Modified macro with rounding:

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

Re: VBA Excel macro for any object geometry modifications

Anonymous — Fri, 28 Sep 2012 13:20:38 GMT

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

Re: VBA Excel macro for any object geometry modifications

Rafal.Gaweda — Fri, 28 Sep 2012 13:31:16 GMT

similar to message 6 in

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

Re: VBA Excel macro for any object geometry modifications

Anonymous — Sat, 18 Jan 2014 14:22:19 GMT

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

Re: VBA Excel macro for any object geometry modifications

Rafal.Gaweda — Mon, 20 Jan 2014 08:55:05 GMT

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/page/3

Re: VBA Excel macro for any object geometry modifications

Anonymous — Thu, 30 Jan 2014 14:56:27 GMT

Hello,

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

Thank you!

Re: VBA Excel macro for any object geometry modifications

Rafal.Gaweda — Fri, 31 Jan 2014 07:38:50 GMT

Robot -> Nodes table

Re: VBA Excel macro for any object geometry modifications

Anonymous — Fri, 31 Jan 2014 08:23:44 GMT

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

Re: VBA Excel macro for any object geometry modifications

Rafal.Gaweda — Fri, 31 Jan 2014 09:24:22 GMT

Example attached.

Re: VBA Excel macro for any object geometry modifications

mgaafar — Wed, 18 May 2016 17:03:52 GMT

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?

Re: VBA Excel macro for any object geometry modifications

Rafal.Gaweda — Thu, 19 May 2016 06:50:58 GMT

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.