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