Discussion Groups

Robot Structural Analysis

Reply
Product Support
Rafal.Gaweda
Posts: 5,587
Registered: ‎04-26-2010

VBA Excel macro for any object geometry modifications (API)

3819 Views, 17 Replies
10-12-2011 05:31 AM

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.



Rafal Gaweda
Please use plain text.
Member
Perhed
Posts: 3
Registered: ‎05-19-2011

Re: VBA Excel macro for any object geometry modifications

10-12-2011 08:26 AM in reply to: Rafal.Gaweda

Hello!

 

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

How should i use the macro?

 

/Per

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,587
Registered: ‎04-26-2010

Re: VBA Excel macro for any object geometry modifications

10-13-2011 12:06 AM in reply to: Perhed

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

 

references.JPG



Rafal Gaweda
Please use plain text.
Member
Perhed
Posts: 3
Registered: ‎05-19-2011

Re: VBA Excel macro for any object geometry modifications

10-14-2011 12:05 AM in reply to: Rafal.Gaweda

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

 

/Per

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,587
Registered: ‎04-26-2010

Re: VBA Excel macro for any object geometry modifications

10-14-2011 12:49 AM in reply to: Perhed

Try: 

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

2. Check \ set UAC :

UAC.jpg

 



Rafal Gaweda
Please use plain text.
Member
Perhed
Posts: 3
Registered: ‎05-19-2011

Re: VBA Excel macro for any object geometry modifications

10-14-2011 01:18 AM in reply to: Rafal.Gaweda

This gives the same error.

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,587
Registered: ‎04-26-2010

Re: VBA Excel macro for any object geometry modifications

10-14-2011 01:30 AM in reply to: Perhed

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
Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,587
Registered: ‎04-26-2010

Re: VBA Excel macro for any object geometry modifications

10-14-2011 04:15 AM in reply to: 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



Rafal Gaweda
Please use plain text.
Active Contributor
RoboExploiter
Posts: 44
Registered: ‎09-04-2011

Re: VBA Excel macro for any object geometry modifications

02-12-2012 05:52 PM in reply to: Rafal.Gaweda

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?

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,587
Registered: ‎04-26-2010

Re: VBA Excel macro for any object geometry modifications

09-28-2012 12:46 AM in reply to: RoboExploiter

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...



Rafal Gaweda
Please use plain text.