| || |
dynamically change the testdata
After executing the scripts by using the QTP, dynamically it should change the testdata.testdata stored in one Excelsheet.
for example we have the data in centralised excel sheet
ex:ORG FOR HP15
after Execution the testdata should be changed to ORG For HP16 Is it possible to do this by using macros in excel.
is it possible to change the Object repository logical name and Physical description of the objects after one iteration of execution with out any manual intervention.
please share your thoughts as soon as possible.
Re: dynamically change the testdata
You can write some VBA in the This WorkBook component, something like:
Private Sub Workbook_Open()
orgFor = "ORG For HP"
tmp = Split(.Cells(1, 1).Value, orgFor)
tmp2 = tmp(1) + 1
newVal = tmp(0) & tmp2
.Cells(1, 1).Value = orgFor & newVal