View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E[_2_] AA2e72E[_2_] is offline
external usenet poster
 
Posts: 93
Default Delete a line in a text file

You need to read the existing file and write out the required lines to a new file, then delete the existing file and rename the new one to the same name

If the lines that you want to omit can be dropped with SQL, you can use the ODBC text driver & ADO to select the lines you want. Then use the GetString method to write the lines to a new file. Amount to the same thing!