save as csv file codepage problem

[ermis1975]

I try to save as csv, but when I open it with another txt editor like notepad it opens with "chinese" fonts!

[Kenneth Hobs]

Saving from what version of xls? Most likely, it is still an xls file and not a csv file.

[ermis1975]

Version 2003. If I use the manual method, without macro, an save as csv, it s ok. In macro its not!

[mdmackillop]

Please post your code. It's hard to assist without seeing it.

[ermis1975]

Sheets("Sheet1").Move
ActiveWorkbook.SaveAs Filename:= _
"C:\TEMP\A.CSV"
ActiveWindow.Close

I try also to put filetype xlCSV with the same results

[ermis1975]

I "fix" the problem, I don;t know how, but inspite of ( ; ) the separete value is (,). What I do wrong ?

[shamsam1]

ActiveWorkbook.SaveAs Filename:="C:\test_change.csv", FileFormat:=xlCSV

[ermis1975]

Its ok now but the Separate string is ( , ) and not ( ; ). !
How can I determine the ( ; ) ?