Has anybody written a macro to copy the contents of a cell into Notepad?

Thanks in advance.

If you want to write the contents of a cell to a text file, then going
through notpad would be a very inefficient way to do it.

http://support.microsoft.com/support...eio/fileio.asp
File Access with Visual Basic® for Applications

Gives you plenty of sample code for writing information to text files.

Chip Pearson also has sample code for writing to a text file:

http://www.cpearson.com/excel/imptext.htm import/export text files

--
Regards,
Tom Ogilvy



"OldCCN" wrote in message
...
Has anybody written a macro to copy the contents of a cell into Notepad?

Thanks in advance.