[RESOLVED] VBA save as CSV, SemiColon

[Radjesh Klauke]

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?

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.

[Siddharth Rout]

Hope this helps you?

Topic: Saving XL files as Text/CSV
Link: http://www.mcgimpsey.com/excel/textfiles.html

[Radjesh Klauke]

Thanks m8.