API problems

[Anonymous]

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

[Romanich]

Do you use Win 8.1 x64 and Office 2013?

[Anonymous]

Windows 7 and Office 2010.

[Rafal.Gaweda · Accepted solution]

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

[Anonymous]

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!