View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Saving spreadsheets as delimited text files

Try changing your windows settings.

In win98:
windows start button|settings|control panel|regional settings applet|
Number tab

At the bottom is a list separator. Change it to the pipe.

Remember that this is a windows property and may affect other programs.



rwebster3 wrote:

I have a need to save data from some spreadsheets as a pipe (|) delimited file. I've been able to import data that way, but have yet to figure out a way (short of writing each cell individually) into this format. Anyone know of a way to preserve the | delimiter after reading in the file?


--

Dave Peterson