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.