Number of Excel Rows

[JDU]

I have a csv file that gets created as a result of an export. How can I figure out how many rows are populated since I have to use it in a code

eg.
For rwindex = 10000 (I wouldn't know this number) To 1 Step -1

 

[fredericofonseca]

Search these forums for "usedrange" and you will find some help

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Zathras]

If your data are in a spreadsheet, you can get the number of rows with the .UsedRange.Rows.Count property.

If your data are only in a file and you are reading individual records, use a Do While not end-of-file type of logic. You don't need the number of rows. (Or if your really do, pre-process the file by counting the number of records in a do while not end-of-file loop.)

 

[fredericofonseca]

Off topic

Zathras

Are you a B5 guy?

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[JDU]

Thanks so much.

 

[Zathras]

Frederico: Indeed, yes. I was very sorry to see it go. Zathras was my favorite character. I know exactly how he feels.