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 of text file

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

--
Regards,
Tom Ogilvy
"Francis Ang" wrote in message
...
I have created a text file using the Open Statement. How do I delete a

specific line say line 3 using VBA codes? Any help is very much
appreciated. Thank you.