View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stevieb stevieb is offline
external usenet poster
 
Posts: 16
Default Pipe-Delimited CSv File

Hello,

My system settings are set to have commas shown as pipes.

But when I use the following command in VB, the output file still uses
commas -

WS.SaveAs "c:\filename.csv", xlCSV

I presume there is a listing of valid "FileFormats". If there is a link,
that would also be appreciated.

Thank you