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.

--
Have a nice day!
Murat Demir Hekimoðlu
+90 542 312 2224

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

--
HTH

Bob Phillips

"Murat Demir Hekimoðlu" <(E-Mail Removed)> wrote in message
news:One$g%(E-Mail Removed)...
> 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.
>
> --
> Have a nice day!
> Murat Demir Hekimoðlu
> +90 542 312 2224
>
>

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.
--
Earl Kiosterud
www.smokeylake.com

"Murat Demir Hekimoðlu" <(E-Mail Removed)> wrote in message
news:One$g%(E-Mail Removed)...
> 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.
>
> --
> Have a nice day!
> Murat Demir Hekimoðlu
> +90 542 312 2224
>
>

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


"Bob Phillips" <(E-Mail Removed)> wrote in message
news:et7J$(E-Mail Removed)...
> If you have a local version of Excel that uses , as a separator, doesn't
> it
> automatically save CSV files with ;?
>
> --
> HTH
>
> Bob Phillips
>
> "Murat Demir Hekimoðlu" <(E-Mail Removed)> wrote in message
> news:One$g%(E-Mail Removed)...
>> 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.
>>
>> --
>> Have a nice day!
>> Murat Demir Hekimoðlu
>> +90 542 312 2224
>>
>>
>
>