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
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