VBA: Error displaying special characters
 

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