Skip to main content

Close All Opened Browsers Except HP Quality Center/ALM

Option : I

Function CloseIEExceptALM()       
        On Error Resume Next
        iCurItr = 0
        bExit = False
        Do            
            Set objDlg = Dialog("regexpwndtitle:=.*Internet Explorer.*","Index:=" & iCurItr)
            If Dialog("regexpwndtitle:=.*Internet Explorer.*","Index:=" & iCurItr).Exist(0) Then
                If objDlg.WinButton("text:=Cancel","Index:=0").Exist(0) Then
                    objDlg.Activate
                    objDlg.WinButton("text:=Cancel","Index:=0").Click
                End If
                If objDlg.WinButton("text:=Close","Index:=0").Exist(0) Then
                    objDlg.Activate
                    objDlg.WinButton("text:=Close","Index:=0").Click
                End If           
                If objDlg.WinButton("text:=Ok","Index:=0").Exist(0) Then
                    objDlg.Activate
                    objDlg.WinButton("text:=Ok","Index:=0").Click
                End If   
                If objDlg.WinButton("text:=Close Program","Index:=0").Exist(0) Then
                    objDlg.Activate
                    objDlg.WinButton("text:=Close Program","Index:=0").Click
                End If   
                If Dialog("regexpwndtitle:=.*Security Warning.*","Index:=0").Exist(0) Then
                    Dialog("regexpwndtitle:=.*Security Warning.*","Index:=0").Activate
                    If Dialog("regexpwndtitle:=.*Security Warning.*","Index:=0").WinBUtton("text:=&No").Exist(0) Then
                        Dialog("regexpwndtitle:=.*Security Warning.*","Index:=0").WinBUtton("text:=&No").Click
                    End If                   
                End If   
                Wait(0.500)
                If objDlg.Exist(0) Then               
                    If objDlg.GetROProperty("Visible") Then
                        strTitle = Dialog("regexpwndtitle:=.*Internet Explorer.*","Index:=" & iCurItr).GetROProperty("title")
                        strText = Dialog("regexpwndtitle:=.*Internet Explorer.*","Index:=" & iCurItr).GetROProperty("text")
                        If InStr(strText, "HP") = 0 Then                                                                                
                            If Dialog("regexpwndtitle:=.*Internet Explorer.*","Index:=" & iCurItr).Exist(0) Then
                            Dialog("regexpwndtitle:=.*Internet Explorer.*","Index:=" & iCurItr).Activate
                                Dialog("regexpwndtitle:=.*Internet Explorer.*","Index:=" & iCurItr).Close
                            End If
                            Wait(0.500)
                            iCurItr = -1
                        End If
                    End If
                End If
            ElseIf iCurItr> 10 Then
                bExit = True           
            End If           
            iCurItr = iCurItr + 1
        Loop Until iCurItr >= 100 Or bExit
        Set objDlg = Nothing
End Function


Option : II
 
Function CloseIEexceptQC()
    Dim oDesc,oChilds,iCnt,i,ihwnd,sName
    Set oDesc=Description.Create
    oDesc("micclass").Value="Browser"
    Set oChilds = Desktop.ChildObjects(oDesc)
    iCnt = oChilds.Count
    For i = 0 to iCnt -1
        sName = oChilds(i).getRoProperty("name")
        If instr(1, sName,"Quality Center") = 0 Then
            ihwnd = oChilds(i).getRoProperty("hwnd")
            SystemUtil.CloseProcessByHwnd(ihwnd)
        End If
    Next

End Function

Comments

Popular posts from this blog

Convert JSON to XML using QTP/UFT/VBScript

Sample Code : Dim strPage,strJSON,objIE strPage = "C:\Jay\JLoader.html" Set objIE = CreateObject("InternetExplorer.Application") objIE.Visible = True objIE.Navigate2 strPage While objIE.Busy : Wend strJSON = "{""FirstName"":""Jay"", ""LastName"":""Krishna""}" Set objWin = objIE.document.parentWindow objWin.execScript "var jsonStr2XML = function(strJSON) { return json2xml(JSON.parse(strJSON));};" Msgbox  oWin.jsonStr2XML(strJSON) objIE.Quit In Detail: Converting The most popular data interchange format JSON(JavaScript Object Notation) to XML using QTP/UFT. Parsing JSON in UFT could be a challenge so we will use JavaScript in UFT to make it perfect. SO We need :              Java Script API  - To Convert JSON to XML                         JavaScript Files :                         http://goessner.net/download/prj/jsonxml/j

Read Outlook mail attachment and Body using Vb Script or QTP

Set olApp = CreateObject("Outlook.Application") Set olns = olApp.GetNameSpace("MAPI") Set ObjFolder = olns.GetDefaultFolder(6) j = 0 For each item1 in ObjFolder.Items        iattachCnt = item1.Attachments.Count     Print "Attachments Count: " & iattachCnt     For i = 1 to iattachCnt         Print "FileName :    " & item1.Attachments(i).FileName         Print "Display Name:   " & item1.Attachments(i).DisplayName         Print "Size: " & item1.Attachments(i).Size     Next     Print " Body : " & item1.body     Print "--------------------------------------Mail Num - " & j & " -----------------------------------------------"     j = j+1    Next

Excel Sorting By Rows and Columns

Excel Sorting By Row: Const xlAscending = 1 Const xlNo = 2 Const xlSortRows = 2 Set objExcel = CreateObject(“Excel.Application”) objExcel.Visible = True Set objWorkbook = objExcel.Workbooks.Open(“C:\Jay\Docs1.xls”) Set objWorksheet = objWorkbook.Worksheets(1) objWorksheet.Cells(1,1).activate Set objRange = objExcel.ActiveCell.EntireRow objRange.Sort objRange, xlAscending, , , , , , xlNo, , , xlSortRows set objExcel=nothing Excel Sorting By Column : Const xlAscending = 1′represents the sorting type 1 for Ascending 2 for Desc Const xlYes = 1 Set objExcel = CreateObject(“Excel.Application”)’Create the excel object objExcel.Visible = True’Make excel visible Set objWorkbook = _ objExcel.Workbooks.Open(“C:\Jay\Docs1.xls”)’Open the document Set objWorksheet = objWorkbook.Worksheets(1)’select the sheet based on the index .. 1,2 ,3 … Set objRange = objWorksheet.UsedRange’which select the range of the cells has some data other than blank Set objRange2 = objExcel.Range

How to Download a file using VbScript

Following is the code to download a file using Vbscript, without using QTP This code uses the HTMLDom and URLDownloadToFile method from urlmon API. Since VBScript does support calling Native API methods directly, here I am using  Excel macro to declare a function for the urlmon API and running the macro by Excel API from VBscript Step1: Create a new excel and open the visual basic editor, Insert Module and paste the following code the Module, save the excel file Private Declare Function URLDownloadToFile Lib “urlmon” Alias _                                            “URLDownloadToFileA” ( _                                            ByVal pCaller As Long, ByVal szURL As String, _                                            ByVal szFileName As String, _                                            ByVal dwReserved As Long, _                                            ByVal lpfnCB As Long) As Long Sub FileSave(strUrl, Des)     r = URLDownloadToFile(0, strUrl, Des, 0, a)

How to Read or Select Context Menu or Right Click Menu using QTP.

Select The Item in Right Click Menu or Context Menu: Window("sampleWindow").WinMenu("MenuObjType:=1).Select"File;New" Here MenuObjtype can be 1 r 2 r 3 .......n Check wether the Item is Exist or Not: If Window("sampleWindow").WinMenu("MenuObjType:=1).GetItemProperty("1","Exist") Then   Msgbox"Exist" Else  Msgbox"Does Not Exist" End If                                         Or If Window("sampleWindow").WinMenu("MenuObjType:=1).GetItemProperty("File","Exist") Then   Msgbox"Exist" Else  Msgbox"Does Not Exist" End If Get the Items in Context Menu: For i = 1 to 10 Print  Window("sampleWindow").WinMenu("MenuObjType:=" & i).GetItemProperty("1","Label") Then Next