| News For Advanced News and Article Search Click Here |
| QTP Script to open password protected excel sheet |
Posted by guest |
May 16 2008
3:22:05 PM |
Set ExcelSheet = Excel.WorkBooks.Open("C:\Name.xls",,False,,"password")
Set WorkBook = ExcelSheet.Worksheets("Data")
Rows = ExcelSheet.Worksheets("Data").UsedRange
|
|
|
| Compare Excel and DB using QTP |
Posted by admin |
May 09 2008
2:18:48 PM |
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("G:\doc.xls" ,,True,, "password")objExcel.Visible = True Window("(Connected to UAT / QA").WinObject("LightSpeed [Read-Only]").DblClick 50,252
Window("(Connected to UAT / QA").WinObject("EXCEL6").Click 27, 7, micRightBtn
Window("(Connected to UAT / QA").WinObject("EXCEL6").Click 13,4
Window("(Connected to UAT / QA").WinObject("EXCEL6").Type DataTable("CUSIP", dtGlobalSheet)
Window("(Connected to UAT / QA").WinObject("LightSpeed [Read-Only]").C...
|
|
|
| Find.Range to find a value in Excel using QTP |
Posted by guest |
April 28 2008
3:31:53 PM |
Set findObj = objWorkBook.Worksheets("CusipList").Range("A1:G354").Find("A")
If Not findObj is Nothing Then
Msgbox findObj.Row
Else
Msgbox "No match found"
End If
|
|
|
| This code will open two excel sheet and compare |
Posted by guest |
April 28 2008
3:30:56 PM |
This code will open two excel sheet and compare each sheet cell by cell, if any changes there in cells , it will highlight the cells in red color in the first sheet.
Set objExcel = CreateObject("EXCEL.APPLICATION")
objExcel.Visible = True
Set objWorkbook1= objExcel.Workbooks.Open("C:\DesktopDocs1.xls")
Set objWorkbook2= objExcel.Workbooks.Open("C:\DesktopDocs2.xls")
Set objWorksheet1= objWorkbook1.Worksheets(1)
Set objWorksheet2= objWorkbook2.Worksheets(1) For Each cell In objWorksheet1.UsedRange
If cell.Value <> objWorkshee...
|
|
|
| guestOrganization of Web Test Tools Listing |
Posted by guest |
March 04 2008
12:46:40 PM |
This tools listing has been loosely organized into the following categories:
Load and Performance Test Tools
Java Test Tools
Link Checkers
HTML Validators
Free On-the-Web HTML Validators and Link Checkers
PERL and C Programs for Validating and Checking
Web Functional/Regression Test Tools
Web Site Security Test Tools
External Site Monitoring Services
Web Site Management Tools
Log Analysis Tools
Other Web Test Tools(Categories are not well-defined and some tools could have been listed in several categories. Note that the 'Web Site Management Tools' category includes products tha...
|
|
|
|
Page 1 of 2
|
Next 5 Topics
|
Home
News Archive
