VBA does not recognize non-English characters

Hello guys,

I have a new laptop with Windows 8.1 bought in the USA and I'm having a difficulties with Excel VBA (Office 365 University-64x bought in the Czech Republic - Central Europe). The VBA does not recognize non-English characters (particularly "" and "") which causes me problem when running some codes that I wrote earlier on my previous laptop (Windows 7, bought in the Czech Republic with the same Office). 
The problem with non-English characters has occurred only in VBA so far, otherwise I can use these characters normally in Excel cells, Word... I tried to install both English and Czech version of the Office with no change, I also installed Czech proofreading tools and set everything to Czech in the Office. The location and language preferences in the Windows are also set up to Czech. And it is not a problem of a font. I also mentioned that when I tried to look up these characters, using Ctrl+F, it changes original to r after a search and again this is only an issue of the VBA.   

Thank you very much for any help.
Tom

January 8th, 2015 6:28pm

Hi Tom,

I would suggest you post the question in the forum of Excel for Developers as your query is directly related to VBA. Here we mainly support Office client side issues:

https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=exceldev

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Regards,

Ethan Hua
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
January 9th, 2015 9:43am

Thank you Ethan, I'll post my problem also to the other forum.
January 9th, 2015 10:39am

I have just faced the same problem. Solved it by changing the Windows' System Locale: Control Panel - Clock, Language and Region - Region - Administrative - Language for non-Unicode programs - Change System Locale

Free Windows Admin Tool Kit Click here and download it now
January 31st, 2015 7:01am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics