Custom File Types
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!
|