Hello guys,
Thank you for your advices, but my problem still remains.
I tried what you suggested (...deselect “Use System Separators” and enter a “,” for Decimal Separator, and a space for Thousands Separator...) but i still get csv with commas instead of semicolumns.
I also tried to use...
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:=...