| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy data - txt file with formatting
I am looking to copy data from excel to a notepad file and want 2 achieve the
following 2 things : 1) Keep the fomat of the text. 2) want to go to the end of the already existing txt file (with data) and add data towards the end. -- Ajit |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy data - txt file with formatting
Ajit,
Plain text files (.txt, .csv etc) do not support formatting. You will have to use another format; RTF, HTML, stay in Excel etc. As for Appending data, There is the Excel method of OpenAsTextStream/OpenTextFile or the VBA way using the Open statement. NickHK "Ajit" wrote in message ... I am looking to copy data from excel to a notepad file and want 2 achieve the following 2 things : 1) Keep the fomat of the text. 2) want to go to the end of the already existing txt file (with data) and add data towards the end. -- Ajit |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data for match word from one file to another file | Excel Worksheet Functions | |||
| How do I copy data into Excel and maintain the formatting? | Excel Discussion (Misc queries) | |||
| Copy data to new cell but with different formatting | Excel Discussion (Misc queries) | |||
| Formatting of Data from .CSV file | Excel Worksheet Functions | |||
| VBA to copy entire sheet data + formatting | Excel Programming | |||
Linear Mode
