| || |
Search / Replace in Excel
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]