save sheet as Unicode CSV

[vsimionescu]

Hello

The problem has been asked before but I couldn't find any satisfactory
answer. In short, I have Excel files which might contain extended
characters such as russian, chinese and others, and I want to get a CSV
out of a given sheet. From programming, that is via OLE. Is there any
decent way to do this ? I mean other than going through every cell,
hand-coding its contents to CSV and writing the file myself.

Regards
V. Simionescu

 

[NickHK]

V,
Excel does have a SaveAs Unicode Text option (which seems to give you a Tab
separated format), but as far as I see, csv will only give you ANSI
characters.

NickHK

 

[vsimionescu]

V,
Excel does have a SaveAs Unicode Text option (which seems to give you a Tab
separated format), but as far as I see, csv will only give you ANSI
characters.

NickHK

Thanks.
I knew that. I was hoping maybe the guys from MS will give an
authoritative answer of either what is to be done or that nothing can
be done.

Vlad