Hi all
New to QTP 8.2

I am testing a 100 page Excel spread sheet.

The recording tool is cute, but I need specific data.

I want to go / search for a specific name tag or “Name Box” in Excel.
Then Read the value of that “Name Box”.
Then Replace that value with a new value.
Then repeat the process with a different “Name Box”.
Each box will have a unique name.


Employees = 100
TempEmpoyees = 120
Computers = 70
Telephones = 100

Function findboxname(“Employee”) [would return address]
Function changeboxvalue (“Employee”, 121) [would find/replace value from 100 to 121]