SOLVED

Umlaute in VBA Office 2019 OEM

%3CLINGO-SUB%20id%3D%22lingo-sub-2135473%22%20slang%3D%22en-US%22%3EUmlaute%20in%20VBA%20Office%202019%20OEM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2135473%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20problem%20with%20Office%202019%20VBA.%20The%20code%20doesn't%20handle%20german%20%22Umlaute%22%20properly.%3C%2FP%3E%3CP%3Eas%20an%20example%20the%20sub%3C%2FP%3E%3CP%3ESub%20testUmlaute()%3CBR%20%2F%3EDebug.Print%20%22Umlaute%20und%20Sonderzeichen%3A%20%C3%84%C3%96%C3%9C%C3%A4%C3%B6%C3%BC%C3%9F%22%3CBR%20%2F%3EEnd%20Sub%3C%2FP%3E%3CP%3Eshows%3C%2FP%3E%3CP%3EUmlaute%20und%20Sonderzeichen%3A%20%C3%AF%C2%BF%C2%BD%C3%AF%C2%BF%C2%BD%C3%AF%C2%BF%C2%BD%C3%AF%C2%BF%C2%BD%C3%AF%C2%BF%C2%BD%C3%AF%C2%BF%C2%BD%C3%AF%C2%BF%C2%BD%3C%2FP%3E%3CP%3EThe%20problem%20is%20not%20only%20in%20Excel%2C%20also%20in%20Word%3C%2FP%3E%3CP%3EMy%20Office%20is%20a%20OEM-Version%3C%2FP%3E%3CP%3E%3CSPAN%3EMicrosoft%20Excel%202019%20MSO%20(16.0.13628.20128)%2032-Bit%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EProduct%20ID%3A%2000405-32289-63043-AAOEM%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWhat%20can%20I%20do%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EB.t.w.%20a%26nbsp%3B%20non-OEM%20version%20of%20Offive%202019%20works%20fine%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2135473%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2135515%22%20slang%3D%22de-DE%22%3ESubject%3A%20Umlaute%20in%20VBA%20Office%202019%20OEM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2135515%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F966815%22%20target%3D%22_blank%22%3E%40hogelaoutlookde%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20could%20suspect%20a%20Windows%2010%20problem%20rather%20(still%2C%20despite%20setting%20in%20German)%20than%20an%20Excel%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20the%20following%20times%2C%20but%20untested%3A%20Start%20button%20-%26gt%3B%20Settings%20-%26gt%3B%20Time%20and%20language%20-%26gt%3B%20Region%20-%26gt%3B%20Additional%20date%20and%20time%20and%20Country%20settings%2C%20which%20ultimately%20leads%20you%3C%2FP%3E%3CP%3Eto%20the%20old%20system%20control%3C%2FP%3E%3CP%3E-%26gt%3B%20region%2C%20which%20shows%20a%20dialog%3C%2FP%3E%3CP%3E-%26gt%3B%20Administration%20tab%3C%2FP%3E%3CP%3E-%26gt%3B%20Second%20button%20%3CBR%20%2F%3E%20with%20the%20designation%20%22Change%20locale%22%20click%20(language%20for%20Unicode)%3C%2FP%3E%3CP%3E-%26gt%3B%20New%20dialog.%20In%20this%20dialog%20there%20is%20an%20option%20%22Beta%3A%20Unicode%20UTF-8%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E...%20%22Is%20the%20checkmark%20set%3F%20If%20yes%2C%20turn%20it%20off.%3C%2FP%3E%3CP%3EYou%20may%20have%20to%20restart%20the%20computer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies

@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.

best response confirmed by hogelaoutlookde (New Contributor)
Solution

@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 ...

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