How can I export a CSV file with semicolon as the delimiter. By defaul
it sets it to a comma. I do not want the comma. Thanks in advance fo
you help.

ActiveWorkbook.SaveAs Filename:="C:\test.csv"
FileFormat:=xlCSV, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False
_
CreateBackup:=Fals

--
bawaho
-----------------------------------------------------------------------
bawahoo's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=55949