Excel to CSV ,chinese charecter export problem

[#1]

Hi All,

I am facing this problem in which I am running a macro to convert excel file containing different coumns(english as well as one or 2 columns with chinese charecters). Now the problem is whenever I am running the Macro ,Excel file generates a CSV but the chinese charecter columns shows value like '?????' in CSV.

I want them to be in same format as in excel .And for me CSV needs to be the source to qlikview which is taking all '??????' as '??????' only.

Please help.

[#2]

In Excel go to File > Save As > Unicode.txt and let me know if that works better.

Why do you have to be using CSV? I don't think that supports funny characters.

[#3]

Its not working Wallerjc. And we are using CSV as a source to reduce size of data plus there are certain guidelines within project in which we can only use CSV files as a source ,thats why we are converting excel into CSV.

Guys suggest some solution to this .Any macro to take these chinese charecters from excel to CSV without converting into any garbage value like '???'

[#4]

Do you need to keep the integrity of the Chinese characters?

[#5]

Yes i want to keep the chinese charecters in CSV as they are in excel.