B
belitre
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
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