Unanswered: Deleting Content Of Flat *.txt File From Excel
I Have The Content Below In Rad.txt File I Want To Delete Without Deleting The File Rad.txt. How Can I Do It?
Nyc Med Doe |||||blue Call|12:30:32|12:31:38|00:01:04|john Doe
Medical Center |x|||||09:09:45|09:09:48|00:00:03|john Doe
Test To See One |||||blue Call|12:42:46|12:42:50|00:00:01|john Doe
Test To See One |x|||||12:42:46|12:43:19|00:00:05|john Doe
Personal Sevices |||||blue Call|12:44:58|12:46:00|00:01:01|john Doe
Like David pointed out you can use the Open text function to read write to a text file. Also Ref the Get, Put methods of the Open Function. I don't think there's a way to delete one line directly. Either keep the lines in a spreadsheet then write the file based on the spread sheet or (more complex) read the file into an array, then write the file out from the array, skipping the line you want deleted.