Display unicode characters in non-English windows

[Terence]

Hi,

I have a VBA program which writes data on a sheet and save
the sheet in DBF format.
Here the nightmare comes, the program puts the
character "¥" (created by Chr(165) in VBA code), then the
program saves the file in DBF format. However, when I open
the DBF file by Excel in Chinese Windows (I suspect this
also happens in other non-English windows), the "¥" cannot
be displayed. But it can be displayed in English windows
without problems.
I am so frustrated by this problem.. Can anyone help?
Thanks a lot.

Terence

 

[jaf]

Hi Terence,
Not sure if your results will be different, but try chrw(0165).
chrw() means use Unicode.


--

John

johnf202 at hotmail dot com


Hi,

I have a VBA program which writes data on a sheet and save
the sheet in DBF format.
Here the nightmare comes, the program puts the
character "¥" (created by Chr(165) in VBA code), then the
program saves the file in DBF format. However, when I open
the DBF file by Excel in Chinese Windows (I suspect this
also happens in other non-English windows), the "¥" cannot
be displayed. But it can be displayed in English windows
without problems.
I am so frustrated by this problem.. Can anyone help?
Thanks a lot.

Terence