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
|