Hi I've made a macro that save an excel file in .csv format.

I've several columns that have numeric format, with two decimal
separated by commas.

I don't have any problem when using Excel SaveAs Dialog.

But when I execute that action in the macro, I get decimals separate
BY POINT and not BY COMMA.

I include the final part of my macro:

' varText has the name of the file

columns("A:M").Select
ActiveWorkbook.SaveAs Filename:= _
"\\Mtdisa\directory\" + varText + ".csv" _
, FileFormat:=xlCSVMSDOS, CreateBackup:=False

Thanks for the attention. Regards

--
Message posted from http://www.ExcelForum.com