Re: Number of rows in xls file

anonymous_at_discussions.microsoft.com
Date: 02/23/04 

Date: Mon, 23 Feb 2004 11:48:36 -0800

No problem with English.
I think I can figure out how to stop the loop from the
examples on your website.

Thanks,
Gerry Metze

>-----Original Message-----
>I hope I understand you correct(my bad english)
>
>You can check in the loop if a row is empty
>
>With Active***
>'code
>If Application.CountA(.Rows(Lrow)) = 0 Then .......
> 'Lrow is the rownumber in the loop
>'code
>End With
>
>
>
>--
>Regards Ron de Bruin
>(Win XP Pro SP-1 XL2000-2003)
>www.rondebruin.nl
>
>
>
><anonymous@discussions.microsoft.com> wrote in message
news:1552e01c3fa40$9d2c4140$a601280a@phx.gbl...
>> Hi Ron --
>>
>> Yes; I can't look for empty rows to stop a reading loop
>> because there are embedded empty rows in the file.
>>
>> I want to read the data into a VB array for further
>> processing.
>>
>> Thanks,
>> Gerry
>>
>>
>> >-----Original Message-----
>> >Hi Gerry
>> >
>> >Am I correct that you want to know how many rows have
>> data on you ***?
>> >Or do you want to know the last used row/column on
your
>> ***
>> >
>> >--
>> >Regards Ron de Bruin
>> >(Win XP Pro SP-1 XL2000-2003)
>> >www.rondebruin.nl
>> >
>> >
>> >
>> >"Gerry Metze" <anonymous@discussions.microsoft.com>
>> wrote in message news:1549501c3fa37$f5506da0
>> $a601280a@phx.gbl...
>> >> I'm trying to automate processing of an .xls file.
Are
>> >> there variables/parameters/whatever I can read that
>> tell
>> >> me how many rows and columns there are in the .xls
>> file?
>> >> The file has several blank lines interspersed, so
>> looking
>> >> for blank lines isn't enough.
>> >
>> >
>> >.
>> >
>
>
>.
>