Results 1 to 7 of 7

CSV Semicolon Comma problem with Macro.

Threaded View

  1. #1
    Registered User
    Join Date
    02-28-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    3

    CSV Semicolon Comma problem with Macro.

    Good Day Everybody,

    We have a slight problem with a macro when we save a xls to csv file when using a macro to do this.

    We made the following macro which saves the current file as a CSV file:

    Sub Opslaan()
    '
    ' Opslaan Macro
    '
    ' Sneltoets: CTRL+o
    '
        Cells.Select
        Selection.Copy
        Workbooks.Add
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
            SkipBlanks:=False, Transpose:=False
        Application.CutCopyMode = False
            ActiveWorkbook.SaveAs Filename:="F:\Ray\Retouren\RetourOpdr_Ray.csv", _
            FileFormat:=xlCSVMSDOS, CreateBackup:=False, Local:=True
        ActiveWindow.Close
    End Sub


    When we use the macro it saves the CSV file with a comma, but we require a semicolon.
    When we save the file manually it always uses a semicolon, because keyboard-settings are on ;

    What do we forget ?

    Thanks and regards,

    Raymond
    Last edited by arlu1201; 03-05-2013 at 06:00 AM. Reason: Use code tags in future.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1