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.