View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Jim Vita Jim Vita is offline
external usenet poster
 
Posts: 13
Default FileSystemObject to get last 10 lines of text file.


John,

I've been looking at the variuous posts here and there are some great
ideas. In the past, I've used the one with the Skip method posted by Dana.
Are you writing the log? If so, have you considered making your log a fixed
record length and using vb random file access. You could do a direct seek
to the 10th record from the end. Random access would be the fastest way to
go. Another possibily is to log to a DB table instead of a file.

Thanks,

Jim

Jim Vita
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.