| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a line in text file
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
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete a line in text file
workbooks.open "C:\My Files\Myfile.txt"
Rows(4).EntireRow.Delete workbooks.Close SaveChanges:=True -- Regards, Tom Ogilvy "Francis Ang" <Francis wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete a line in text file
Thanks Tom.
"Tom Ogilvy" wrote: workbooks.open "C:\My Files\Myfile.txt" Rows(4).EntireRow.Delete workbooks.Close SaveChanges:=True -- Regards, Tom Ogilvy "Francis Ang" <Francis wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| output to the same line in a Text file? | Excel Discussion (Misc queries) | |||
| 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 | |||
| End of file marker from Text File - Delete? | Excel Programming | |||
![Francis Ang[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
