If your requirement is to pass the values to an external excel sheet then you will have to exploit the Excel COM object.
This would write in the 1st row, 4th column provided that is your results column. If you want to write it for all the tests please iterate through a For loop and use the counter in place of the row.
Code:
Set oExcel = CreateObject("Excel.Application")
Set oWorkbook = oExcel.Workbooks.Open(sExcelpath)
Set oWorksheet = oWorkbook.Worksheets(1)
If ..("Window"). ..("Screen"). ..("Field"). = "desired result" Then
oWorksheet.Cells(1, 4).Value = "Pass"
Else
oWorksheet.Cells(1, 4).Value = "Fail"
End IfThis would write in the 1st row, 4th column provided that is your results column. If you want to write it for all the tests please iterate through a For loop and use the counter in place of the row.
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.