saveas (;) seperated csv file [Problem]

  • Thread starter Thread starter Murat Demir Hekimoðlu
  • Start date Start date
M

Murat Demir Hekimoðlu

Hello all

I have a problem saving an Excel File (;) seperated csv file instead of (,)
seperated file. I am using VBA macro below. Does anyone have a sloution for
that problem.

ActiveWorkbook.Worksheets("Sheet1").SaveAs Filename:= _
pName, FileFormat:=xlCSV, _
CreateBackup:=False

thanx all.
 
If you have a local version of Excel that uses , as a separator, doesn't it
automatically save CSV files with ;?
 
Hi

I think this problem is because of regional setings but the I couldnt find
the seperator settings. Excel dont save (;) as a deafult seperator. Instead
it uses local seperator settings. So I wrote a little function that makes
the conversion with the (;) and then save the file as csv. I think that is
the only solution.....

Have a nice day!
Murat
 
Back
Top