save as csv (comma separated) produces ???? values for russian charachters

[rickmeister]

Hi,

Does someone know if there is a workaround to save an xlsx file as comma separated csv file without losing the special charachters (portuguese, spanish, russian, ...) in utf8 ?

My current code enables to save the file as csv where special characters are preserved BUT I do not have the comma separated...

Can I include this into the vba code by any chance?

thanks,

' Save as XLSX

xlsname = Application.GetSaveAsFilename & "xlsx"

Application.DisplayAlerts = False
Application.DisplayAlerts = True

ActiveWorkbook.SaveAs Filename:=xlsname, FileFormat:=xlOpenXMLWorkbook, ConflictResolution:=xlLocalSessionChanges

ActiveWorkbook.Save

'Save as CSV

csvName = Left(xlsname, InStr(1, xlsname, ".") - 1) & ".csv"

ActiveWorkbook.SaveAs Filename:=csvName, FileFormat:=xlUnicodeText, local:=False

ActiveWorkbook.Save

MsgBox "Files successfully created!"
         
 
    ' To suppress excel prompts and alert messages while the macro is running.
 
 Application.DisplayAlerts = False
 ActiveWorkbook.Close False

    
  Unload Me