Save to CSV with VBA problem

[Cameraman84]

Hello to everyone

I have a small problem...When I save my xlsm page in CSV UTF-8 with simple way File --> Save As --> .... the file is saved correctly and works normally.

΅When I save with this VBA code:

Application.DisplayAlerts = False
Sheets("SYSTEM (CSV)").SaveAs Filename:=ThisWorkbook.Path & "\CSV UTF-8 - SYSTEM.csv", FileFormat:=xlCSVUTF8, CreateBackup:=False

The file don't work normally.

When i open the files with text editor, the differences is that when i save with VBA, every row take first the symbol " and then crash in the program....any idea please?

I give you a piece from texts file to see the differences


Saved with simple way and works normally.
No,Name,Surname,Position,Exact Position,Nationality,Date of Birth,Age,Height (cm),Height (m),Weight,Foot,T-shirt,Instagram,Total GK,Total DF,Total MF,Total FW,Players GR,Total L. Foot,Total R. Foot
STARTING 11

Saved with VBA and don't works normally.
"No,Name,Surname,Position,Exact Position,Nationality,Date of Birth,Age,Height (cm),Height (m),Weight,Foot,T-shirt,Instagram,Total GK,Total DF,Total MF,Total FW,Players GR,Total L. Foot,Total R. Foot"
STARTING 11


Thanks for all
John K.

 

[ranman256]

use: FileFormat:=xlCSV
works just fine.

but your data may all exist in 1 cell.