Posted to microsoft.public.excel.programming
|
|
export CSV file with semicolon
Chip Pearson's site:
http://www.cpearson.com/excel/imptext.htm import/export text files
Allows you to specify the delimiter.
--
Regards,
Tom Ogilvy
"bawahoo" wrote:
How can I export a CSV file with semicolon as the delimiter. By default
it sets it to a comma. I do not want the comma. Thanks in advance for
you help.
ActiveWorkbook.SaveAs Filename:="C:\test.csv",
FileFormat:=xlCSV, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False,
_
CreateBackup:=False
--
bawahoo
------------------------------------------------------------------------
bawahoo's Profile: http://www.excelforum.com/member.php...o&userid=15102
View this thread: http://www.excelforum.com/showthread...hreadid=559494
|