How to get the number of used rows from excel spreadsheet in VBScr

I need a piece of script, that connects to an ALREADY OPEN excel spreadsheet
and get the number of used rows, using VBScript. So far I was unable to do it
and I found solutions only in VB or other languages. Please help if you know
how to.
Thanks,
Judit

Hi JP

You can use
MsgBox ActiveSheet.UsedRange.Rows.Count

Remember this is not always give you the last row with data.
The usedrange not always start in row 1



--
Regards Ron de Bruin
http://www.rondebruin.nl



"JP" <[email protected]> wrote in message news:[email protected]...
>I need a piece of script, that connects to an ALREADY OPEN excel spreadsheet
> and get the number of used rows, using VBScript. So far I was unable to do it
> and I found solutions only in VB or other languages. Please help if you know
> how to.
> Thanks,
> Judit

Thanks for the help, but my problem really is not to get the used rows but
first to get an object reference to an already open excel spreadsheet. If I
run this line it will give me and error "Object required 'ActiveSheet'", so I
need to find out how to get an object reference to an already open excel
sheet. It would be gread if you could help me with that.
Thanks a bunch.
Judit

"Ron de Bruin" wrote:

> Hi JP
>
> You can use
> MsgBox ActiveSheet.UsedRange.Rows.Count
>
> Remember this is not always give you the last row with data.
> The usedrange not always start in row 1
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "JP" <[email protected]> wrote in message news:[email protected]...
> >I need a piece of script, that connects to an ALREADY OPEN excel spreadsheet
> > and get the number of used rows, using VBScript. So far I was unable to do it
> > and I found solutions only in VB or other languages. Please help if you know
> > how to.
> > Thanks,
> > Judit
>
>
>