Read previous line of textfile

  • Thread starter Thread starter Adrian
  • Start date Start date
A

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?
 
Probably easiest to open it in Excel, then work from the last row to the
first.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Strip records from large textfile with VBA 4
How can I make Excel read a value from a textfile and assign it to a variable in my VBA code?? 2
retrieving Text from a textfile in Excel 2
How can I overwrite the last line data in text or csv file from VB 1
VBA Multiple Line handling with Split() 1
Manipulate textfile with VBA 3
looping through text files in a folder 2
Save data from Notebook: copying to the USB stick using Linux and the command line 0

Back
Top