Excel VBA: Cannot display special characters in non-English windows

[terencechung]

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
.

 

[sfvb]

From what I read, there's an outside shot that chr(36) (which is the dollar sign in the US), may work.

I found a lot of info by using "chinese currency symbol" at Google.

Good luck.