Compare 2 Excel sheets cell by cell

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(“path of 1st xls document”) Set objWorkbook2= objExcel.Workbooks.Open(“path of 2nd xls document”) Set objWorksheet1= objWorkbook1.Worksheets(1) Set objWorksheet2= objWorkbook2.Worksheets(1)    For Each cell In objWorksheet1.UsedRange       ...

Read More

Introduction to Descriptive Programming:Descriptive programming is used when we want to perform an operation on an object that is not present in the object repository. There can be various valid reason to do so. We will discuss them later in this article. How to write Descriptive Programming?  There are two ways in which descriptive programming can be used 1. By giving the description in form of the string arguments. 2. By creating properties collection object for the description. 1. By giving the description in form of the string...

Read More

In case your QTP 10.0 crashes frequently…

Go To command prompt. [Start > Run > Type cmd] Change directory to C:\Program Files\HP\QuickTest Professional\bin using the command cd C:\Program Files\HP\QuickTest Professional\bin Type in nt_tr.exe –remove as shown in the image below.  You will see a message box stating Text recognition has been uninstalled. Reboot machine. It should work without reboot as well but just in case. Try...

Read More

Decrypt an Encrypted Password automatically

It is well known that recording a login sequence results in code similar to this: Login Script with Browser("Gmail").Page("Gmail") .WebEdit("Email").Set "mygmail@gmail.com" .WebEdit("Passwd").SetSecure "5068b16874876c920b65d2036ace62c8103fecd0bbf8b7bfc7d2" .WebButton("Sign in").Click end with Where QTP uses the SetSecure method for the Password field and records the encrypted string that represents our raw input password. One frequent question asked in forums is how is it possible to decrypt such a...

Read More