CSV and number format

[oro77]

Hello,

I am saving my workbook in a CSV file but I have a problem with number from 1000, it will automatically write it like :
"1,000". Is there a way to put the number without quote and comma (1000) ?

I searched in the SaveAs property but I did not find any option, have I miss-looked ?

Set WB = Workbooks.Open(fname, True, True, local:=True)
WB.SaveAs Filename:=fname, FileFormat:=xlCSV, CreateBackup:=False, local:=True

The file I initially open is an Excel file with number formatting.
I don't know if it is clear but I would like to ignore the Excel number formatting when I create my CSV file.

EDIT:

I found the solution using the CorruptLoad with the xlExtractDat parameter !

Set WB = Workbooks.Open(fname, True, True, local:=True, CorruptLoad:=xlExtractData)

Thank you in advance.