Unable to run the OTA macros on 64 bit windows 7 machine

[Raghavan25]

Hi All,

I have a template where i have written macros in excel using OTA to pull the data from QC . It is currently working fine in 32 bit Windows 7 but not working in 64 bit windows 7 machines.

Can someone help me out in this regard ? Should i include anything in my code for this ?

I am getting the following error messages when i run my macro

Error # 1
Run-time error '429'
ActiveX component can't create object

Error #2
Run-time error '424'
Object Required