While connecting with QC using VBA or VB Script using QC OTA library encountered an error message which says "Active X Component Can't Create Object".
After couple of hours debugging found issues in my OTA library and the simple resolution is to install TD Connectivity add in again.
Below are the steps listed that will guide you to how to install addin.
Step1: Open your QC URL which might be ( http://<server address>//qcbin.
Step2: Navigate to Addin Page.
Step3: It is free and easily downloadable as well.
Step4: After installation the code disappear and scripts start working.
Let me know if any more help is required on this.
Apart from this I did try re-registered my dll into registry editor but didn't help.