Connecting excel vba to ALM 15

Hi All,

Am trying to load data into ALM 15 test plan using excel macro. So when establishing connection between excel vba and ALM 15 am getting error as "Activex component cannot create object" 429 .below is the code i used. Can you suggest me on how to establish the connection  between excel vba and ALM 15 (without SSO)

Set QCConnection = CreateObject (:"TDApiOle80.TDConnection")

QCConnection.InitConnectionEx "ALM url"

 

TIA

 

Parents
  • Two possible reasons:
    1. Did you register ALM client files? Go to Tools page -> ALM Client Registration -> Register ALM to perform registration.
    2 Did you run the script in 64 bit Excel? If yes, you need to update registration information accordingly. Below thread can be referred.
    https://community.microfocus.com/t5/ALM-QC-User-Discussions/Workaround-OTA-amp-64-Bit-Applications-Excel-Word-etc/m-p/1639028
    Good luck!
Reply
  • Two possible reasons:
    1. Did you register ALM client files? Go to Tools page -> ALM Client Registration -> Register ALM to perform registration.
    2 Did you run the script in 64 bit Excel? If yes, you need to update registration information accordingly. Below thread can be referred.
    https://community.microfocus.com/t5/ALM-QC-User-Discussions/Workaround-OTA-amp-64-Bit-Applications-Excel-Word-etc/m-p/1639028
    Good luck!
Children
No Data