| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Define Excel delimiter by file extension
Exel 2000 on XP Professional
I have a server than produces pipe ( | ) separated text files. The files all end in .psv (pipe separated vaules). I would like to be able to click on one of these files and have Excel open the file and parse it much the same way it does .csv files. I have defined the file type, but I do not know of any way to pass values to Excel telling it to open files of this type as pipe separated text files. -- Rob White Louisville, KY |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
| Copy and paste special - values into new excel file | Excel Discussion (Misc queries) | |||
| Can I embed or link multiple .pdf files into or to an excel file? | Excel Discussion (Misc queries) | |||
| Excel not detecting that a file is currently being edited | Excel Discussion (Misc queries) | |||
| double click a xls file and start Excel but without the file | Excel Discussion (Misc queries) | |||
Threaded Mode
