Excel VBA - Japanese font

[OneSource]

Hi and thanks for reading.

I have an Excel spreadsheet that successfully displays Japanese characters. But when I try to access the text or value property of a cell with these characters in VBA, all I get is question marks returned in place of the actual characters. (e.g., if I type "? cells(1,1).text" in the immediate pane, I get ????????????? returned.)

How can I access the actual Japanese characters in VBA?

For what it's worth, languages such as French, Spanish, Dutch, etc. are handled just fine.

Thanks!
OneSource

[Ecniv]

Its probably to do with Unicode (two bytes per character instead of one).

Try looking at these functions:
AscW
ChrW

and a search for unicode conversion/help.


Vince

[OneSource]

your response helped!

OneSource