Export specific cell data to txt delimited file

[Guest]

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]

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

 

[Billkamm]

You may be able to create formulas such as VLOOKUP or paste as links
to another sheet and then save that page as a text file. If it is
more complex than that I recommend looking in to the following
commands:

Open "filename.txt" For Append As #1
Write #1, yourDataVariable
Close #1

Also, you may do "Output" instead of "Append" to create a new file.

Billkamm
irc.24oz.net #Excel