ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Delete a line of text file (https://www.excelbanter.com/excel-programming/300855-delete-line-text-file.html)

Francis Ang[_3_]

Delete a line of text file
 
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.

Tom Ogilvy

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.




All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com