Exporting Excel Data to Notepad

Subs · Aug 30, 2004

Hi

Does any body know where I can find any generic code that would export data
out of Excel into notepad.

Thanks in Advance

mk · Aug 30, 2004

Does any body know where I can find any generic code that would export
data

out of Excel into notepad.

Look here. I have used that code and it works perfectly.

Dave Peterson · Aug 30, 2004

How about exporting the values to a text file (and open that text file in
NotePad if you really want):

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

Fabian · Aug 31, 2004

Subs hu kiteb:

Hi

Does any body know where I can find any generic code that would
export data out of Excel into notepad.

I believe excel (every version) can save as comma separated variable
files (csv), which can be understood by notepad.