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
