Polish and other non-ASCII special characters in VBA and Excel’s macros

With introduction of the "new" Microsoft Office’s file formats (XML-based, i.e. DOCX, XLSX etc.) Microsoft has finally solved problem of Unicode support and storing and displaying special characters in documents, spreadsheets, presentations etc. The only problem is that they’ve forgotten about Visual Basic for Applications and macros which still are using dully ANSI encoding.

The fastest solution is out of Excel and is based on altering Windows 10 control panel settings to instruct Windows how it should interact with applications that do not fully support Unicode.

But, suppose you don’t want to or can’t change your system settings. Then what?

Quick Google search revealed some possible solution, including:

Since I failed on finding a correct solution, I had to dig myself own one. Here’s the deal…

Read More “Polish and other non-ASCII special characters in VBA and Excel’s macros”