Setting up VB to work with foreign languages

[yaniv-bl]

When I have a cell with a foreign language string (let's say Chinese) and I want to add it into a VB variable for some reason I get question marks instead of Chinese charters in that variable (although the characters are presented as they should in the XL sheet).

Can anyone tell me what I need to do in order to enable VB to recognize foreign languages?

Thanks!

 

[yaniv-bl]

Hi,

I'm still waiting for help.

Thanks.

 

[xenou]

Try googling VBA Unicode and see if you find some hits.

For instance this seemed to have some helpful info and links:
http://bytes.com/groups/ms-access/324134-unicode-vba

Let me know how this goes. There's probably others here with more experience so keep asking if you still have troubles.

 

[Greg Truby]

Assuming that the same would hold true for Japanese, you might send a private message to Jindon and see if he can help you. Be sure to include a link to your thread here so he doesn't have to go searching for it.

 

[yaniv-bl]

Thank you both. I will look into your ideas and post back once I find the solution.

In the meanwhile any other ideas would be appreciated.