Set xl=Createobject("Excel.Application")
Set y=x.workbooks.open ("path")
Set z=y.worksheets("Sheet1")
Row_count=z.usedrange.rows.count
msgbox row_count
On Mon, Dec 12, 2011 at 3:12 PM, sirisha chigurupati
<[email protected]>wrote:
> Hi All,
>
> How to get rowcount of an excel file that is opened during runtime.
>
> Regards,
> Sirisha Chigurupati
>
> --
> You received this message because you are subscribed to the Google
> "QTP - HP Quick Test Professional - Automated Software Testing"
> group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/MercuryQTP?hl=en
--
Regards
Shashidhar
+91 -8125564879
[email protected]
--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en