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

Hello,

My system settings are set to have the list seperator = ( | ) , not ( , ).

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