View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] fabio.rossetti@gmail.com is offline
external usenet poster
 
Posts: 2
Default saving in CSV with a nonstandard list separator - possible bug or

On 29 Mag, 16:54, Joel wrote:
You are asking a silly question. CSV means Commar - seperated - Values. If
the data was semiicolon seperated then it would be SSV. Anyway, here is code
that will do what you want.


Well, then there wouldn't be a need to have the list separator setting
in Control panel or the local parameter in the SaveAs method, then,
wouldn't it.. :-) Semicolons are a necessity especial for countries
where the comma is used as a decimal separator. I thought about
avoiding excel altogether and write directly to a text file, but I had
already a routine that originally outputted in xls, so..