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
Bookmarks