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

(You may be happy with Earl's version--right out of the box!)

garyngkt wrote:

Hi,

How do I convert certain cells in a excel sheet to data files which is
in tab delimited format or separated by pipe "|"?. I know that this can
be done manually by copying the cells into a new sheet, then perform the
"Save As" function.

But is there a macro which can do this automatically?.

Here is an example of the section which I need to convert to a data
file.

1 - 100,000.00 - -
2 - 100,000.00 - -
3 78.60 100,000.00 149.36 149.36
4 119.10 100,000.00 194.48 352.80
5 160.30 100,000.00 239.52 613.49
6 202.40 100,000.00 284.64 934.94

Thanks and appreciate your help.

Kind regards,
Gary Ng
:)

--
garyngkt
------------------------------------------------------------------------
garyngkt's Profile: http://www.excelforum.com/member.php...o&userid=14974
View this thread: http://www.excelforum.com/showthread...hreadid=265998

--

Dave Peterson