View Single Post
  #1   Report Post  
Robbie
 
Posts: n/a
Default 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