Download defects from QC to Excel using QC OTA

Dim tdcSet tdc = CreateObject(“TDApiOle80.TDConnection”) Dim sUserName, sPasswordsUserName = “” ‘sPassword = “” ‘ Dim sDomain, sProjectsDomain = “”   ‘sProject = “” ‘ tdc.InitConnectionEx “http://qc..com/qcbin” ‘tdc.Login sUserName, sPassword tdc.Connect sDomain, sProject If (tdc.LoggedIn <> True) Then    MsgBox “QC User Authentication Failed”    ‘WScript.QuitEnd If Fn_Defects_To_Excel() ‘========================================  ‘To download defects from QC to excel sheet ‘========================================= Sub…

Arrays in VBScript

An Array variable can have different data type values like int, char, string, Boolean etc An Array variable values can be assigned or retrieved by using it’s index, index can not be -ve. An Array variable can be single/multi dimension: if multi dimension variable, can have up to 60 dimension. Static Array variable – ‘Declaration…