PDA

View Full Version : Excel 2007 VBA error 429; ActiveX component can't create object



ManishM
12-09-2012, 06:19 AM
Hi,
Macro solution needed for the above error. The below code has been working completely fine on Windows XP 32 bit, excel 2007 but failed on Windows 7 enterprise 64 bit. below is the code :-
-----------------------------------------------------------------------------------------------
Dim RT As RmsRiskToolsFactory ' i have set the correct path in the tools-- references
Set RT = New RmsRiskToolsFactory ' error on this line
Run-time error '429':
ActiveX component can't create object
-----------------------------------------------------------------------------------------------
I have also searched through other forums but not much of help. I am not good at windows registry/command prompt programming which other sites suggested. if you could help me stepwise, I would really appreciate your effort. looking forward for your assistance.
Kind regards,
Manish

Bob Phillips
12-09-2012, 09:24 AM
Cross-posted at Egghead Cafe http://www.eggheadcafe.com/community/excel/66/10469869/excel-2007-vba-run-time-error-429-activex-component-cant-create-object-windows-7-64-bit.aspx

ManishM
12-09-2012, 09:34 AM
hi,
I do agree that the same has been posted at eggheadcafe but looking for a solution urgently and posted at same date at both side. any help would be highly appreciated.

Kind regards,
Manish

ManishM
12-09-2012, 10:21 PM
hi,
does anyone have any idea to resolve the above problem?

Kind regards,
Manish