Autodesk Robot Structural Analysis
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
VBA Excel macro for any object geometry modificati ons (API)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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
Product Support
Autodesk, Inc.
Re: VBA Excel macro for any object geometry modificati ons
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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 modificati ons
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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

Rafal Gaweda
Product Support
Autodesk, Inc.
Re: VBA Excel macro for any object geometry modificati ons
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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 modificati ons
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Try:
1. Run Excel as Administrator, run Robot as Administrator, then check macro
2. Check \ set UAC :

Rafal Gaweda
Product Support
Autodesk, Inc.
Re: VBA Excel macro for any object geometry modificati ons
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
This gives the same error.
Re: VBA Excel macro for any object geometry modificati ons
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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
Product Support
Autodesk, Inc.
Re: VBA Excel macro for any object geometry modificati ons
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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
Product Support
Autodesk, Inc.
Re: VBA Excel macro for any object geometry modificati ons
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Hello,
I had the same problem which i managed to solve with the help of the structural support team:
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 modificati ons
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
JUst to link some threads .
Modified macro with rounding:

Rafal Gaweda
Product Support
Autodesk, Inc.


