Opening a data file with over 65000~ rows

**toggel** · 07-15-2009, 12:03 PM

Hello everyone,

Another day another problem! My problem is that I have to use a macro I have written (with much help from this forum)
that auto generates charts from data files. The problem I have is I must now use it on data files that will contain more than 65000 rows of data.
The problem with this is that you can not open a file with that many rows of data in excel. My question to you VBA pros is as follows..

Is there a way to open the data file in say notepad so I can count the number of rows and make any needed changes (say only take every other data point).
I am no to worried about make the modifications I am just stumped on how or if I can open the file in some other way before exporting
it into excel. Also if it helps the files are saved as example.dat if this helps.

Thank you all again this is one of the most helpful forums I have been on in a very long time!

**mrice** · 07-15-2009, 02:40 PM

Two answers.

Get Excel 2007 which copes with over 1000000 rows.

or use a function like the one below to count the numer of lines in a file.

Please Login or Register  to view this content.

**Phil_V** · 07-15-2009, 02:55 PM

The other (faster) option maybe to not load the data onto a worksheet at all, but rather to open it as per Martin's function and then process the data in an array or similar.

**toggel** · 07-15-2009, 04:56 PM

yes thank you martin as getting excel 2007 is not an option I will use your method to count the rows and then manipulate a data array as need.
Thank you very much I will let you know how it goes.