Excel 97: Exporting Cell values to text files.

[JW]

I was wondering if it is possible to set up a macro where you can sort
a set of information once, then export certain cell values to a text
file, and then sort it again, and export a different set of cell
values to that same text file.

I know how to get the Macro going and adding a sort to it, but I'm
just not sure 1. if its possible to send cell values to a text file
and 2. how one would program that into the macro.

Thanks.

 

[Dave Peterson]

Here's a couple of links that may give you an idea:

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

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

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