save a csv file with SEMICOLON delimiters

[mariofontaine]

Hello,

In a Excel Macro (VBA) I'm trying to save a ".xls" file into a ".csv
file with SEMICOLON ";" delimiters. There is the code :

ActiveWorkbook.SaveAs FileName:="test", _
FileFormat:=xlCSV, CreateBackup:=False

But when I open the result file, the delimiters are comma ",". Do yo
have a solution to save the file with semicolon ";" ?

Thank you very much in advance

 

[Harald Staff]

Hi

See Chip Pearson's
http://www.cpearson.com/excel/imptext.htm
for a very customizable code solution.

HTH. Best wishes Harald

 

[mariofontaine]

Thank's a lot, I really appreciate !

Have a nice day