API problems

Anonymous — Tue, 18 Mar 2014 02:05:00 GMT

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

Re: API problems

Romanich — Tue, 18 Mar 2014 07:24:38 GMT

Do you use Win 8.1 x64 and Office 2013?

Re: API problems

Anonymous — Tue, 18 Mar 2014 07:53:07 GMT

Windows 7 and Office 2010.

Re: API problems

Rafal.Gaweda — Tue, 18 Mar 2014 15:19:29 GMT

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

Re: API problems

Anonymous — Tue, 18 Mar 2014 16:07:39 GMT

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!

topic Re: API problems in Robot Structural Analysis Forum

API problems

Re: API problems

Re: API problems

Re: API problems

Re: API problems