FileSystemObject question
As you suspected,
Read the file into a variable, open it for write and write it out minus the
first five lines
or open it in excel, delete the rows and save it.
Regards,
Tom Ogilvy
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
|