Read previous line of textfile
 

I have a text file that I want to read line by line, but
BACKWARDS !!

The ReadLine method reads the next line.
But I need to read the last line first, then the previous
line, working backwards to the beginning etc etc.
(Each line needs to be the right way round within itself.)
The text files are typically 50,000 lines long.

Any ideas?

Read previous line of textfile
 

Probably easiest to open it in Excel, then work from the last row to the
first.

--
Regards,
Tom Ogilvy

"Adrian" wrote in message
...
I have a text file that I want to read line by line, but
BACKWARDS !!

The ReadLine method reads the next line.
But I need to read the last line first, then the previous
line, working backwards to the beginning etc etc.
(Each line needs to be the right way round within itself.)
The text files are typically 50,000 lines long.

Any ideas?

Read previous line of textfile
 

Read the whole file into a variable and use split(strVar,vbvrlf) to
assign it to an array.

Then work from the upper to lower bound of the array.

Tim.


"Adrian" wrote in message
...
I have a text file that I want to read line by line, but
BACKWARDS !!

The ReadLine method reads the next line.
But I need to read the last line first, then the previous
line, working backwards to the beginning etc etc.
(Each line needs to be the right way round within itself.)
The text files are typically 50,000 lines long.

Any ideas?