Has anybody written a macro to copy the contents of a cell into Notepad? Thanks in advance.
O OldCCN Jul 7, 2004 #1 Has anybody written a macro to copy the contents of a cell into Notepad? Thanks in advance.
T Tom Ogilvy Jul 7, 2004 #2 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/excel/content/fileio/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
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/excel/content/fileio/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
