Hello,
I am trying to save excel file as csv semicolon delimited file. While I was doing it manualy (File->Saveas->CSVcommaDelimited) it worked fine, but with macro it gives me file with commas (without semicolumns)!?
My macro (main part) is:
Activeworkbook.SaveAs Filename:=..., Fileformat:=xlCSV, Local:=True
I set Windows Regional Settings List Separator to ";" (as it was suggested in some Excel forums) but it still wont not work properly
Does anyone knows what causes this problem and how to solve it ?
I am trying to save excel file as csv semicolon delimited file. While I was doing it manualy (File->Saveas->CSVcommaDelimited) it worked fine, but with macro it gives me file with commas (without semicolumns)!?
My macro (main part) is:
Activeworkbook.SaveAs Filename:=..., Fileformat:=xlCSV, Local:=True
I set Windows Regional Settings List Separator to ";" (as it was suggested in some Excel forums) but it still wont not work properly
Does anyone knows what causes this problem and how to solve it ?