Delete a line in text file
 

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

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

Delete a line in text file
 

Thanks Tom.

"Tom Ogilvy" wrote:

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