Delete a line in text file

[Francis Ang]

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

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

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

 

[Francis Ang]

Thanks Tom.

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

--
Regards,
Tom Ogilvy


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