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