Getting 'Unknown runtime error'

[UFT_Newbie]

Hi Guys,
I'm running below script and i'm getting "Unknown runtime error" at ObjWorkSheet.Rows(StartRow).Columns(Environment("Execute")).Value.

Code:

Environment("Execute")="1" Set ObjExcel = CreateObject("Excel.Application") ObjExcel.Visible = True Set NewExcelfile = ObjExcel.Workbooks.Open("c:\temp\1.xls") Set ResultFile= NewExcelfile Set ObjWorkSheet=ResultFile.Worksheets("Sheet2") For i = 13 To 323 StartRow = i ExecuteStatus = ObjWorkSheet.Rows(StartRow).Columns(Environment("Execute")).Value If ExecuteStatus = "Y" Then Browser("ABC").Page("XYZ").WebButton("EFG").Click Else msgbox "Button not visible" End If Next

Can some please help me out with this issue.

[anshika.agarwal]

I dont know why in your statement you have rows.column i.e.

Code:

ExecuteStatus = ObjWorkSheet.Rows(StartRow).Columns(Environment("Execute")).Value

Do you mind trying

Code:

ExecuteStatus = ObjWorkSheet.Cells(StartRow,Environment("Execute")).Value

[anshika.agarwal]

Hi I thought I replied on this

Do you mind trying :

Code:

ObjWorkSheet.Cells(StartRow,Environment("Execute")).Value

[UFT_Newbie]

@Anshika: I tried that code as well but didn't work. I found the what the problem was. When i'm declaring variable for Environment("Execute")="1", it needs to be 1. It was reading "1" as string and not integer. Thanks for helping.