View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Trouble with csv export...

Ignore that first portion of my reply. That showed how to import the file--not
export.

But you can change the list separator.

Thomas Sedlaczek wrote:

Hello,

I have some trouble with the csv export of an Excel document using VBA.

When I save the document on a German computer using the command below it
seperates the cells by semicolon, but if I do this no an English machine (XP,
Office 2003) it uses comma insead. Why? And is there an easy workaround?

Regards, Thomas

ActiveWorkbook.SaveAs Filename:=Pfad_Datei, FileFormat:=xlNormal,
CreateBackup:=False '


--

Dave Peterson