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

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