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

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

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

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


Aldo wrote:

I have a workbook with several worksheets that are all identical in design.
I would like to take data from specific cells throughout the workbook and
place the data into a .txt file for merge purposes. Each set of data are in
one column in three cells. Is there an example of this somewhere. I'm not a
programmer, but have managed to adapt examples to specific needs. Any
suggestions are welcome.

Thanks,
Aldo

--

Dave Peterson