Forum Discussion
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
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
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 ... 😉
3 Replies
- Thank you for letting me help you. For further questions I am gladly at your disposal "I know that I know nothing" in Ancient Greek (oîda oudén eidōs). So with his testimony, Socrates does not claim that he does not know anything. Rather, it questions what you think you know. your Welcome Nikolino 🙂
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.
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 ... 😉
