VBA does not recognize non-English characters

Question

_{Thursday, January 8, 2015 3:28 PM}

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

All replies (3)

_{Saturday, January 31, 2015 12:00 PM ✅Answered}

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

_{Friday, January 9, 2015 6:43 AM}

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

It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.

_{Friday, January 9, 2015 7:39 AM}

Thank you Ethan, I'll post my problem also to the other forum.