Delete a line in text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
workbooks.open "C:\My Files\Myfile.txt"
Rows(4).EntireRow.Delete
workbooks.Close SaveChanges:=True

--
Regards,
Tom Ogilvy

Francis Ang said:
I have created a text file using the Open Statement. How do I delete a
Click to expand...
specific line say line 4 of the text file using VBA. Any help is very much
appreciated. TIA
 
Thanks Tom.

Tom Ogilvy said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete a line in a text file 3
Delete a line of text file 1
How open notepad.exe and write text line by line via excel vba? 2
How write into text file at first and last line with excel vba? 3
Modifying a LARGE text file 2
Excel VBA help: Text file formatting 19
Word to Excel: Export comments with text and line number 0
Word Removing unwanted "lines" within a MS Word 10 table 1

Back
Top