Read previous line of textfile

[Adrian]

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?

 

[Tom Ogilvy]

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

 

[Tim Williams]

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.