View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlotte E.[_3_] Charlotte E.[_3_] is offline
external usenet poster
 
Posts: 160
Default Delete all, but the last 23 lines of an external text file

Hi Guys,


I have a workbook that write a new line to an external (text file) log each
day.
This works fine no problem here...

But we really only need to be able to view the lines for the past month - in
fact even only the last 23 lines in the log file, since there are never more
than 23 workdays in a month.

So, how to delete all but the last 23 rows in an external text files, using
VBA?


TIA,

CE