VBA Excel : Run time error '429': ActiveX component can't create object

I working on VBA with Excel, Which working fine with windows OS (32 bit) and office 2007(office 32 bit) When i started work on Windows 8 (64 bit) and office 2010 (64 bit) i was unable to run the application so for below line of code i added because of excel office 2010 is comes with VBA7.

Please Login or Register  to view this content.

it worked fine But when i try to Access the Application(excel sheet) i am getting

Error "Runtime Error 429 - ActiveX Component Can't Create Object "


My Problem : I Have Issue only with 64 bit Windows 8 and 64 bit Office 2010
1. did any mistake in above Declared Code ?
2. Can force to run 32 bit COM object on 64 bit OS and How ?

Here creating the COM Object

Please Login or Register  to view this content.

Yes If we want to execute on 64 bit office.

Is there any alternative for that code or solutions ?

You are right..

i sure i have reference for SriptControl and leave it NavFunctions (no need of use NavFunctions)

No need for the declarations of NavFunctions , but i need to declare ScriptControl