Another source of information.
Chip Pearson has written sample code for doing this, both for importing and
exporting.

http://www.cpearson.com/excel/imptext.htm

--
Regards,
Tom Ogilvy

frank wrote in message
...
Is there a way to create a csv type file BUT select my
own character to seperate the variables. Comma's won't
work as there are comma's in the data!!

Tx, Frank