View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Delete a line in text file

workbooks.open "C:\My Files\Myfile.txt"
Rows(4).EntireRow.Delete
workbooks.Close SaveChanges:=True

--
Regards,
Tom Ogilvy

"Francis Ang" <Francis wrote in message
...
I have created a text file using the Open Statement. How do I delete a

specific line say line 4 of the text file using VBA. Any help is very much
appreciated. TIA