Hi there,

I'm exporting a sheet to a csv-file, but it seperates it with a comma. How do I change it so it saves it with a semicolon?

Code:
Set fd = Application.FileDialog(msoFileDialogSaveAs)
    savepath = "D:\blabla\"

    Application.DisplayAlerts = False

    With fd
        .AllowMultiSelect = False
        .Title = "Export"
        .InitialFileName = savepath & ActiveSheet.Name & uname
        .FilterIndex = 15
        If .Show = True Then
            ActiveSheet.SaveAs ActiveSheet.Name & uname, xlCSV, False
        End If
    End With
    Set fd = Nothing
    Application.DisplayAlerts = True
Setting the Local:=False in the SaveAs, doesn't work either.

Thanks for the help in advance.