Hi,
How do I get my hands on a copy of the latest Robot Object Model API? My excel VBA addin developed for ARSA 2010 is not finding an open version of ARSA 2012.
And can someone give me a list of changes between the two object modeslI so i don't need to find the errors in my code one at a time during execution?
Thanks.
Solved! Go to Solution.
Solved by Rafal.Gaweda. Go to Solution.
Look at this thread
Rafal thanks.
I did what the thread suggested, unregistered both versions, reregistered 2012. The Robot Object Model 2012 is now available as a reference. However, now another error has occured:
Run-time error '429': ActiveX component can't create object
I assume this error is now occuring due to changes in my computers registry. Any ideas?
Check this :
http://support.microsoft.com/?kbid=184898
If it does not help please contact me by Private Message
Try also what is suggested in last post in this thread:
Hi Guys,
Just thought I'd close out this post. Adopting the solution provided in this post:
Resulted in "Run-time error '429': ActiveX component can't create object" during execution of my VBA code.
The reason for this error is most probably changes to the registry.
The only way my IT department and I managed to fix this error was to unistall and reinstall MS Office. Its just a little worrying that following the provided solution would impact on other installed software.
Cheers.
Hi Guys,
I'm reopening this post. "Run-time error '429': ActiveX component can't create object" during execution of my VBA code, has not been resolved.
The reason for this error is most probably changes to the registry.
I've tried many methods to fix the registry and have reinstalled MS Office.
Please advise.
Try this:
open VBA macro, go to references and uncheck Robot Object MOdeler reference, confirm closing.
Run macro, errors will be reported, stop macro
go to references and add Robot Object MOdeler reference,
run macro.
If problem persists, run macro in debug mode (line by line) and make screen capture of line on which the problem occurs.
Hi Rafal,
Why would tuning the reference off and on solve the problem?
I've attached print screens.
If I hover over the command: "Robot.Project.IsActive" the floating information says <ActiveX component can't create object>. I can't capture this with a print screen.
Please advise.
replace:
Set Robot = CreateObject(“Robot.Application”)
by
Set Robot = new RobotApplication
and report what happens
The procedure described in last post of this thread :
helps but it must be done with ADMINISTRATOR RIGHTS
Yes, don't know why it didn't work the first time as I had admin rights the first time as well. Anyway, problem solved, thanks for your help.
Can't find what you're looking for? Ask the community or share your knowledge.