How can I export cell content in Excel to a text file?

[Guest]

I have almost 700 rows of cells, each of which needs to be exported to a new
text file. Is this possible to do programmatically please?

 

[Tom Ogilvy]

Chip Pearson's page on importing from and exporting to text files. You
should be able to adapt the code about half way down the page

http://www.cpearson.com/excel/imptext.htm

 

[warren13]

Hello
I have a work book with 60 sheets each sheet has alot of rows
I would like to export each row as a text file, nameing the text file from column A placing everything in the row into the text file.
in total it will be over 32000 text files way to many to do manualy

can anyone offer some generious help it would be greatly appriciated.
thanks