Export specific cell data to txt delimited file

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top