| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display unicode characters in non-English windows
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display unicode characters in non-English windows
Hi Terence,
Not sure if your results will be different, but try chrw(0165). chrw() means use Unicode. -- John johnf202 at hotmail dot com "Terence" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I use macro to find and replace unicode characters | Excel Discussion (Misc queries) | |||
| Hyperlinks to another file are changed to unicode characters | Excel Discussion (Misc queries) | |||
| Saving double-byte characters as unicode text in a CSV file | Excel Discussion (Misc queries) | |||
| Extra characters exported in unicode(.txt) format | Excel Discussion (Misc queries) | |||
| inserting unicode characters | Excel Discussion (Misc queries) | |||
Linear Mode
