Hi guys,
I'm having trouble getting Excel VBA to communicate with Robot 2014.
It started with a run-time error 429 'ActiveX component can’t create object’ on calling the RobotApplication function: ".Kernel.Structure.Results.Query(result_params, row_set)"
Looking at the forums this suggested component registration problems. I have Robot 2010, 2012 and 2014 installed on my machine so have had problems with the incorrect version being registered before.
I tried everything I could find on the forums including the following commands in a batch file run as admin:
"C:\Program Files (x86)\Autodesk\Autodesk Robot Structural Analysis 2010\SYSTEM\EXE\Robot.exe" /unregserver
"C:\Program Files\Autodesk\Autodesk Robot Structural Analysis Professional 2012\System\Exe\Robot.exe" /unregserver
"C:\Program Files\Autodesk\Autodesk Robot Structural Analysis Professional 2014\System\Exe\Robot.exe" /regserver
I also tried registering the R2014 RCOM.DLL file again as this worked for me in the past:
"c:\windows\system32\regsvr32" "C:\Program Files\Autodesk\Autodesk Robot Structural Analysis Professional 2014\System\Exe\rcom.dll"
And then eventually I tried unregistering the R2010 and R2012 DLLs before re-registering the R2014 DLL:
"c:\windows\system32\regsvr32" /u "C:\Program Files (x86)\Autodesk\Autodesk Robot Structural Analysis 2010\SYSTEM\EXE\rcom.dll"
"c:\windows\system32\regsvr32" /u "C:\Program Files\Autodesk\Autodesk Robot Structural Analysis Professional 2012\System\Exe\rcom.dll"
"c:\windows\system32\regsvr32" "C:\Program Files\Autodesk\Autodesk Robot Structural Analysis Professional 2014\System\Exe\rcom.dll"
And then I tried doing all of the above in various different orders with no success.
Now the link between Excel VBA and Robot is nearly completely broken. After successfully creating a new RobotApplication object I get the run time error 430 'Class does not support Automation or does not support expected interface' when I try to check the .Visible property.
What can I do to fix this?
Thanks, Rory
Solved! Go to Solution.
Solved by Rafal.Gaweda. Go to Solution.
Do you use Win 8.1 x64 and Office 2013?
Do you find the posts helpful? "LIKE" these posts!
Have your question been answered successfully? Click 'ACCEPT SOLUTION' button.
Roman Zhelezniak
Robot Evangelist & Passionate Civil Structural Engineer
Solution:
http://forums.autodesk.com/t5/Robot-Structural-Analysis/API-error/m-p/3519462#M5816
MOST IMPORTANT : rcom.dll should be downloaded from this post on forum
Believe the issue was that I needed the 32-bit RCOM.DLL to match my 32-bit version of Excel, but the 64-bit Robot 2014 is installed with the 64-bit RCOM.DLL.
Thanks Rafal!