Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
How do I delete a few words from a line of text? | Excel Worksheet Functions | |||
Delete a line in a text file | Excel Programming | |||
Delete a line in text file | Excel Programming | |||
End of file marker from Text File - Delete? | Excel Programming |