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

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