Umlaute in VBA Office 2019 OEM

I have a problem with Office 2019 VBA. The code doesn't handle german "Umlaute" properly. as an example the sub Sub testUmlaute() Debug.Print "Umlaute und Sonderzeichen: ÄÖÜäöüß" End Sub shows ...

excel

hogelaoutlookde
Feb 15, 2021
NikolinoDE
Hi Nikolino,
it works fine now.
Thank you for the fast respones
Horst
PS despite Socrates' statement: he DID knew a lot, didn't he ... 😉

NikolinoDE

Platinum Contributor

Feb 15, 2021

hogelaoutlookde

One could suspect a Windows 10 problem rather (still, despite setting in German) than an Excel problem.

Try the following times, but untested: Start button -> Settings -> Time and language -> Region -> Additional date and time and Country settings, which ultimately leads you

to the old system control

-> Region, which shows a dialog

-> Administration tab

-> Second button
with the designation "Change locale" click (language for Unicode)

-> New dialog. In this dialog there is an option "Beta: Unicode UTF-8

... "Is the checkmark set? If yes, turn it off.

You may have to restart the computer.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

hogelaoutlookde