How to verify data in excel sheet dowloaded from web appln

[Ravi_Chandra]

Hi,

Found solution for my query. Used below code to retreive the row count from an open application:

Code:

Set objExcel = Createobject("Excel.Application")
Do
     Wait(2)
Loop Until objExcel.Visible = True
rowCount = objExcel.ActiveWorkbook.ActiveSheet.usedrange.rows.count

Thanks,
Ravi.