save a csv file with SEMICOLON delimiters
 

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

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

save a csv file with SEMICOLON delimiters
 

Hi

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

HTH. Best wishes Harald

"mariofontaine " skrev i
melding ...
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 you
have a solution to save the file with semicolon ";" ?

Thank you very much in advance.


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

save a csv file with SEMICOLON delimiters
 

Thank's a lot, I really appreciate !

Have a nice day

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