Results 1 to 7 of 7
  1. #1
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Instalaton language (All)

    How do I convert the following codes to a string such as "English US"?
    Is there a collection available of all the installation languages?

    ' User interface language
    lngLanguageID = Application.LanguageSettings.LanguageID(msoLanguag eIDUI)
    ' Installation language
    lngID = Application.LanguageSettings.LanguageID(msoLanguag eIDInstall)

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Instalaton language (All)

    I guess using a lookup table:

    ISO Code Locale
    1 1033 English United States
    7 1049 Russian
    31 1043 Dutch Standard
    32 1036 French Belgian
    32 1043 Dutch Belgian
    33 1036 French Standard
    34 1034 Spanish Traditional
    34 1034 Spanish Modern
    39 1040 Italian Standard
    41 1031 German Swiss
    41 1036 French Swiss
    41 1040 Italian Swiss
    43 1031 German Austrian
    44 1033 English United Kingdom
    45 1030 Danish
    46 1053 Swedish
    46 1053 Swedish Finland
    47 1044 Norwegian Bokmal
    47 1044 Norwegian Nynorsk
    49 1031 German Standard
    351 2070 Portuguese Standard
    352 1031 German Luxembourg
    352 1036 French Luxembourg
    358 1035 Finnish

    (These are all I could find, there must be a comprehensive list somewhere...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Instalaton language (All)

    You can find the complete listing here.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Instalaton language (All)

    I would need to generate such a list automatically to return the actual strings used to represent the language.
    In Word, I can generate such a list for the proofing languages, but I do not yet see a way to do this for the installation languages.

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Instalaton language (All)

    Unfortunately the list in KB 221435 is incomplete and does not give the correct language name.

    For example, using the Languages collection to generate the languages used for proofing tools, I find codes, 1113, 2080, 2145, and 16393 associated with India.

    However, KB 221435 does not include 2080, 2145 and 16393.

    There is an msoLanguageID class that represents all the numeric codes, but I have not yet found a way to automatically generate the codes for that class and the associated name.

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Instalaton language (All)

    Since you already seem to have a way of getting the language from a number (from the proofing tools), I would generate a complete listing in an Excel worksheet and use a lookup function to get the language from the number.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Instalaton language (All)

    I cannot be assured that will work since the mso constants and the languages for proofing tools do not necessarily match up.

    I'll just have to rely on the mso constants that I can Copy from Help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •