export CSV file with semicolon


B

bawahoo

How can I export a CSV file with semicolon as the delimiter. By defaul
it sets it to a comma. I do not want the comma. Thanks in advance fo
you help.

ActiveWorkbook.SaveAs Filename:="C:\test.csv"
FileFormat:=xlCSV, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False
_
CreateBackup:=Fals
 
Ad

Advertisements

Ad

Advertisements

B

bawahoo

Thanks for the post.

I tried and it does not work. I am using the SAVEAS and not the
Export.

ActiveWorkbook.SaveAs Filename:="T:\prowin2\AGENCY LONG TERM
PMT PLANS-PSI\HOSP\2006\REFERRAL\PSIHREF_" & Format(Now, "MMDDYY") &
".csv", FileFormat:=xlCSV, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False,
_
CreateBackup:=False

Any other suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top