Get the list of Available domains and Project in Excel Macro

  • Questions
  • Get the list of Available domains and Project in Excel Macro
Question ID: 107457
1
0

Hi All,

I am trying to get all the domain and project (respective of domain selected) in Excel Macro
Below is the code that i am using but giving the output as below

Domain:
D1
D1
D1
D1
D2

Project:
P1
P2
P3
(P1 to P3 are from D1)
P4 (P4 is from D2)

Dim QCConnection
‘Return the TDConnection object.
Set QCConnection = CreateObject("TDApiOle80.TDConnection")

Dim sUserName, sPassword
sUserName = txtUname.Text
sPassword = txtPass.Text
Application.ScreenUpdating = False

QCConnection.InitConnectionEx "http://tac-qc-prod.cibc.com/qcbin/"
QCConnection.Login sUserName, sPassword

For Each project In projectList
cmbdom.AddItem (project.DomainName)
cmbprj.AddItem (project.Name)

Next project

Debug.Print domaintext
Debug.Print Ptext
End Sub

Marked as spam
Posted by (Questions: 1, Answers: 2)
Asked on February 16, 2017 2:31 pm
28 views
Answers (1)
0
Private answer

Have you tried to display a messagebox for the project.DomainName as it iterates through the For to see what the property value is?

Marked as spam
Posted by (Questions: 2, Answers: 477)
Answered on January 15, 2018 10:52 pm
EyeOnTesting