View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Steve Yandl[_3_] Steve Yandl[_3_] is offline
external usenet poster
 
Posts: 117
Default FileSystemObject question

Tod,

I think I'd ask this one in the vbscript newsgroup.

If you're going to do this with scripting, you probably should create an
array, reading the text file a line at a time to add elements to the array
as strings. This way you can establish a set number of lines you want to
retain. After the array is complete, delete the old log file and build a
new one, deleting the first elements to retain the number of lines you want.

Steve


"Tod" wrote in message
...
This is kinda sorta the right NG for this question.

My code is appending to a text file each day, like this:

Set fso = CreateObject("Scripting.FileSystemObject")
Set txtStream = fso.OpenTextFile("C:\Path\Log.txt", 8)
txtStream.WriteLine (Now & ": File Updated")
txtStream.Close

The log file gets updated about five times each day, so
the file gets longer each time. I'd like to have code that
deletes x number of entries from the top of the list. How
do I do that?

tod