| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reading an external text file | Excel Programming | |||
| IF, ADD TEXT. DELETE LINES AND RETURN VALUE... | Excel Worksheet Functions | |||
| How to check if external .txt file has text in it... | Excel Programming | |||
| excel97 vba to append lines to text file overwriting last 2 lines | Excel Programming | |||
| Get External Data, Import Text File, File name problem | Excel Programming | |||
![Charlotte E.[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
