saveas (;) seperated csv file [Problem]

[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.

 

[Bob Phillips]

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

 

[Earl Kiosterud]

Murat,

You may need to change the list separator character in Windows Regional
Settings (Control Panel). Failing that, try the Text Write Program at
www.smokeylake.com.

 

[Murat Demir HEKIMOGLU]

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