Excel is very particular with CSV.

Even opening CSV (in VBA) has quirks...
Consistent importing can be achieved only by renaming the file to .TXT
before opening... then use OpenText method.

Saving delimited files, with proper quotes around items, and
"selectable" delimiter..

try ASAP utilities..

http://www.asap-utilities.com/





keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"frank" wrote:

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