as long as you found an answer somewhere, somehow, that's all that matters.

--


Gary

"Charlotte E." <@ wrote in message ...
Sorry for a late reply, but I've spendt the week-end playing with your
code-example :-)

Got it to work - thanks :-)


CE



Charlotte E. wrote:
I have a spreadsheet that writes some logging of its approach to a
text-file, using:

Open LOGFile For Append As #FileNumber


However, over time this text-file just keeps on growing!
And, I really just need to be able to see the latest entries :-)


Is there any way to determine of the text file has grown to, say 100
lines? And, if there is, is there any way to delete all, but the last
100, lines in the text file?

Using Append makes the last 100 lines in the text file into the 100
latest entries, so it really need to be the first lines of the text
file that get deleted...

And it is not an option to delete the text file, since the logging
only makes around 10 lines a day, and I need to be able to view at
least a week back, thus approx. 100 lines...


Can this be achived?


TIA,

CE