You could create a macro that exports the data the way you want.
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
(or maybe you could build your own formula and copy|paste into Notepad.)
Check out Earl's Text Write program first. It may do exactly what you want
right out of the box.
Kurt Barr wrote:
I need to export an excel file into a tilde delimted format. Is there any way
that I can do this programmatically, either by having the tidle (~) already
in the file, or by having a macro insert it between the columns?
--
Dave Peterson