I'd rename the file to .txt

Then use file|open. You'll see the text to columns wizard open up and you can
specify delimited by a semicolon.

You could also change your windows regional settings list separator to
semicolon.



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