View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mike[_49_] Mike[_49_] is offline
external usenet poster
 
Posts: 19
Default read last line of a file

On Sun, 23 Nov 2003 at 01:14:35, Jonas Caspersson (Jonas Caspersson
) wrote:
Do you know in advance how the files i structured? eg it's created by you,
or is it a standard text file intended to read?
If not intended to read, i stronly recomend to use an other format like
random acccess ilo text mode.
If you still have to use text mode there is no better way than to loop
through the file untill EOF is reported, maybe LineInput might be faster...

Just realised the lines in the files are of fixed length - so can use
losmac's method once I have determined the length

I need them to be flat file format for something else that reads those
files
--
Mike
Please post replies to newsgroup to benefit others
Replace dead spam with ntl world to reply by email