1

Office VBA allows you to query the language used by a particular Office application. For example, executing:

? Application.LanguageSettings.LanguageID(msoLanguageIDUI)

in the immediate window will yield 1031 (German) on my system, since this is what I chose as my Office UI language.

The LanguageSettings.LanguageID property supports the following MsoAppLanguageID enum values as a parameter:

Name Value Description
msoLanguageIDExeMode 4 Execution mode language.
msoLanguageIDHelp 3 Help language.
msoLanguageIDInstall 1 Install language.
msoLanguageIDUI 2 User interface language.
msoLanguageIDUIPrevious 5 User interface language used prior to the current user interface language.

I understand the meaning of the latter four values, but what on earth is the execution mode language?

Improve this question
5
  • Note: Some trial and error tests suggest that this is the Windows region/locale setting that was active when the Office application started (3079 = "German (Austria)" on my system), but I'd prefer an authoritative source for this. Commented Nov 18, 2024 at 11:44
  • 3
    documentation.help/MS-Office-VB/ofproLanguageID.htm Commented Nov 18, 2024 at 11:57
  • 1
    @macropod: Oh! I didn't think about checking old, obsolete versions of the documentation. I wonder why they removed it from the current version... Commented Nov 21, 2024 at 14:12
  • @Heinzi have you found an authoritative source for the language? I try to find the language id for what's called "preferred authoring language", I for example have the UI set to english, but data formatting is german because of said authoring value. Commented Dec 1 at 15:02
  • @ximarin: Unfortunately, no, I have no idea how to set/get that language setting through VBA. Commented Dec 1 at 20:52
Related questions
2191
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
1365
What is a correct MIME type for .docx, .pptx, etc.?
606
Is there a way to crack the password on an Excel VBA Project?
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.