• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    Autodesk Robot Structural Analysis

    Reply
    Product Support
    Posts: 2,527
    Registered: ‎04-26-2010

    VBA Excel macro for any object geometry modifications (API)

    1847 Views, 11 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
    Product Support
    Autodesk, Inc.
    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: RG_Adsk

    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
    Posts: 2,527
    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
    Product Support
    Autodesk, Inc.
    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: RG_Adsk

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

     

    /Per

    Please use plain text.
    Product Support
    Posts: 2,527
    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
    Product Support
    Autodesk, Inc.
    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: RG_Adsk

    This gives the same error.

    Please use plain text.
    Product Support
    Posts: 2,527
    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
    Product Support
    Autodesk, Inc.
    Please use plain text.
    Product Support
    Posts: 2,527
    Registered: ‎04-26-2010

    Re: VBA Excel macro for any object geometry modifications

    10-14-2011 04:15 AM in reply to: RG_Adsk

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

    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
    Posts: 2,527
    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
    Product Support
    Autodesk, Inc.
    Please use plain text.