Feb 15 2021 12:55 AM
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
Umlaute und Sonderzeichen: �������
The problem is not only in Excel, also in Word
My Office is a OEM-Version
Microsoft Excel 2019 MSO (16.0.13628.20128) 32-Bit
Product ID: 00405-32289-63043-AAOEM
What can I do
B.t.w. a non-OEM version of Offive 2019 works fine
Feb 15 2021 01:12 AM
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.
Feb 15 2021 01:28 AM
SolutionHi Nikolino,
it works fine now.
Thank you for the fast respones
Horst
PS despite Socrates' statement: he DID knew a lot, didn't he ... ;)
Feb 15 2021 01:57 AM
Feb 15 2021 01:28 AM
SolutionHi Nikolino,
it works fine now.
Thank you for the fast respones
Horst
PS despite Socrates' statement: he DID knew a lot, didn't he ... ;)