Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.
Sep 10, 2003
2
HK
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
.

 
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.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top