Delete a line of 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 3 using VBA codes? Any help is very much appreciated. Thank you.
 
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 3 using VBA codes? Any help is very much
appreciated. Thank you.
 
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 in text file 2
How open notepad.exe and write text line by line via excel vba? 2
Word to Excel: Export comments with text and line number 0
How write into text file at first and last line with excel vba? 3
Modifying a LARGE text file 2
Word Removing unwanted "lines" within a MS Word 10 table 1
Delete first line From CSV file from excel 1

Back
Top