You should be able to write any information you want to a file, therefore
you could use any delimiter you want. It just takes a little more coding
(you would need to cycle through each cell of data, and concatenate the
delimiter between each value before writing the line of data) . You can
also save the file to any extension you would like.
Paul D

"Robert Minneman" wrote in message
...

I want to save a file with a particular delimmiter,
however it appears that Excel only has 2 delimiter type
files to save to.

I'd like to not have to manually change the delimiter each
time I save the file.

Is there a way to create a custom file type that I could
select that would have my chosen delimiter?

IE: Instead of .CSV with a comma as a field separator,
I'd like to have a ".DAT" or something with a pipe, | , as
the separator.

Thanks!

Yes, that's one possibility, however I was hoping for
something much more readily used when opening and
manipulating a lot of these files.

Plus, with a custom file type defined, I wouldn't have to
specify the delimmiter every time I opened the file and go
through the file import process, every time.

-----Original Message-----
You should be able to write any information you want to a
file, therefore
you could use any delimiter you want. It just takes a
little more coding
(you would need to cycle through each cell of data, and
concatenate the
delimiter between each value before writing the line of
data) . You can
also save the file to any extension you would like.
Paul D

"Robert Minneman"
wrote in message
...

I want to save a file with a particular delimmiter,
however it appears that Excel only has 2 delimiter type
files to save to.

I'd like to not have to manually change the delimiter
each
time I save the file.

Is there a way to create a custom file type that I could
select that would have my chosen delimiter?

IE: Instead of .CSV with a comma as a field separator,
I'd like to have a ".DAT" or something with a pipe, | ,
as
the separator.

Thanks!


.