Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I hide unused file types from file types list in save dial | Excel Discussion (Misc queries) | |||
Charts - Custom Types - Line Column - Data Series | Excel Discussion (Misc queries) | |||
built-in custom chart types | Excel Discussion (Misc queries) | |||
2 data types (same col/dif times), do: custom? parse? 2col? | Excel Discussion (Misc queries) | |||
Activate Built-in chart in Custom Types tab | Charts and Charting in Excel |