Export specific cell data to txt delimited file
 

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

Export specific cell data to txt delimited file
 

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

Export specific cell data to txt delimited file
 

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


"Aldo" wrote in message ...
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