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
How to make Excel Vba to use ARSA 2012?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
I have ARSA 2011 nad 2012 installed.
I have an excel based vba script that does some stuff in robot.
i added the “Robot Object Model” on the list of available
libraries fromARSA 2012 folder.
When I start my macro it still launches ARSA 2011.
How could I make it to use ARSA 2012 instead?
or choose between them?
I have Win 7 pro 64bit and MS Excel 2007 32bit
ARSA 2011 32bit
ARSA 2011 64bit
From SDK (both versions)
Dim Robot As New RobotApplication
Robot.Project.New I_PT_FRAME_2D
Robot.Project.Structure.Nodes.Create 1, 0, 0, 0
....
Where could I indicate which version of Robot to use?
If you find my post useful give me Kudos. Thank you!
If my post solved your problem, accept it as a solution.
Solved! Go to Solution.
Re: How to make Excel Vba to use ARSA 2012?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Priit,
Try to register the correct version of Robot before launching the script.
Start > Programs > Autodesk > ARSAP2012 > Tools > ARSAP Component Registration
If you find your post answered press the Accept as Solution button please. This will help other users to find solutions much faster. Thank you.

Artur Kosakowski
Support Specialist
Product Support
Autodesk, Inc.
Re: How to make Excel Vba to use ARSA 2012?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Does not work for me.
If you find my post useful give me Kudos. Thank you!
If my post solved your problem, accept it as a solution.
Re: How to make Excel Vba to use ARSA 2012?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Try to unregister Robot 2011 using Start > Run
"C:\Program Files\Autodesk\Autodesk Robot Structural Analysis 2011\SYSTEM\EXE\robot.exe" /unregserver
and then register Robot 2012
"C:\Program Files\Autodesk\Autodesk Robot Structural Analysis 2012\SYSTEM\exe\robot.exe" /regserver
Mind to set the correct paths.
If you find your post answered press the Accept as Solution button please. This will help other users to find solutions much faster. Thank you.

Artur Kosakowski
Support Specialist
Product Support
Autodesk, Inc.
Re: How to make Excel Vba to use ARSA 2012?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
I am sad to inform, that this did not work either.
I did:
- Run "C:\Program Files (x86)\Autodesk\Autodesk Robot Structural Analysis Professional 2011\System\Exe\robot.EXE" /unregserver
- Run "C:\Program Files\Autodesk\Autodesk Robot Structural Analysis Professional 2012\System\Exe\robot.EXE" /regserver
- Then cheked Excel VBA references . It has "Robot Object Model ver 12.0" checked (loaded from C:\Program Files\Autodesk\Autodesk Robot Structural Analysis Professional 2012\System\Exe\robotom.tlb)
- Then I Open C:\Program Files\Autodesk\Autodesk Robot Structural Analysis Professional 2012\SDK\Samples\Silo_generation.xls
- And it still starts ARSA Pro 2011
(I do not want to remove 2011 version as i need to use Revit 2011 and Robot 2011 versions also).
Win 7 pro 64bit
MS Excel 2007 32bit
ARSA Pro 2011 32bit
ARSA Pro 2012 64bit
Should Rxcel 32 bit be able to communicate with Robot 64bit?
If you find my post useful give me Kudos. Thank you!
If my post solved your problem, accept it as a solution.
Re: How to make Excel Vba to use ARSA 2012?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Looking at the list of the application I think that the cause of the issue can be the way WIN7 handles the registry of 32 and 64-bit applications. Please try to unregister both versions of Robot and ten register 2012. Does this help?
If not, try to unistall 32-bit version of Robot 2011 and install 64-bit one instead. I think that for both Robot being the 64-bit applications the registration procedure should work as intended.

Artur Kosakowski
Support Specialist
Product Support
Autodesk, Inc.
Re: How to make Excel Vba to use ARSA 2012?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Unistalled ARSA pro 2011 32bit
I unregistered(/unregserver) and reregistered ( /regserver) ARSA pro 2012 64bit
Added the “Robot Object Model ver12” on the list of available libraries fromARSA 2012 folder.
When start sample "Silo generation" (or other) from SDK samples i get error :Compile Error. Can't find project or library" (attached pic)
When I close MS Excel 2007 (32bit) and reopen it has lost the “Robot Object Model ver12” from "references -VBAProject".
Any suggestions?
If you find my post useful give me Kudos. Thank you!
If my post solved your problem, accept it as a solution.
Re: How to make Excel Vba to use ARSA 2012?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
This may be a problem with the vba cache.
Please try the following:
- Remove the reference to the “Robot Object Model ver12”
- Run “Generate Silo” (errors)
- Add the reference to the “Robot Object Model ver12”
- Run “Generate Silo”
What is the result?

Artur Kosakowski
Support Specialist
Product Support
Autodesk, Inc.
Re: How to make Excel Vba to use ARSA 2012?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Steps that solved the issue for me.
- Unistall ARSA pro 2011 32bit. no change
- Unistall + install ARSA pro 2012 64bit. Started working
- installed ARSA pro 2011 64bit. Started using 2011 version again.
- 2011 /Unregserver. 2012 /regserver
- Run ARSA pro 2012, it prompts for registration of stuff. Now it works again.
(do not have time to try switching between them).
If you find my post useful give me Kudos. Thank you!
If my post solved your problem, accept it as a solution.
Re: How to make Excel Vba to use ARSA 2012?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
For the switch: mind to run unregserver and regserver as administrator (e.g. you can use Total Commander started as Administrator for this operation or run cmd.exe as administrator).

Artur Kosakowski
Support Specialist
Product Support
Autodesk, Inc.

