Determine excel language

[DS NTE]

How can I determine witch language excel "uses"?
My problem is that som users have an english version and some users have an
norwegian version. This causes problems when working with commandbars:

Norwegian: Set CmdBarMenu = CmdBar.Controls("Verktøy")
English: Set CmdBarMenu = CmdBar.Controls("Tools")

Is there a global method of doing this so this language issue wont cause me
any trouble?


knut

[Bob Phillips]

Use the Toolbar Id


Set CmdBarMenu = Application.CommandBars.FindControl(ID:=30007)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DS NTE" <sorry@no.email> wrote in message
news:eQ6s7$xqFHA.4072@TK2MSFTNGP09.phx.gbl...
> How can I determine witch language excel "uses"?
> My problem is that som users have an english version and some users have
an
> norwegian version. This causes problems when working with commandbars:
>
> Norwegian: Set CmdBarMenu = CmdBar.Controls("Verktøy")
> English: Set CmdBarMenu = CmdBar.Controls("Tools")
>
> Is there a global method of doing this so this language issue wont cause
me
> any trouble?
>
>
> knut
>
>
>
>

[Tom Ogilvy]

see the Excel VBA help on the Application.International function.

--
Regards,
Tom Ogilvy

"DS NTE" <sorry@no.email> wrote in message
news:eQ6s7$xqFHA.4072@TK2MSFTNGP09.phx.gbl...
> How can I determine witch language excel "uses"?
> My problem is that som users have an english version and some users have
an
> norwegian version. This causes problems when working with commandbars:
>
> Norwegian: Set CmdBarMenu = CmdBar.Controls("Verktøy")
> English: Set CmdBarMenu = CmdBar.Controls("Tools")
>
> Is there a global method of doing this so this language issue wont cause
me
> any trouble?
>
>
> knut
>
>
>
>

[DS NTE]

Thank you - got it working!!!

knut
"Tom Ogilvy" <twogilvy@msn.com> skrev i melding
news:%231Gx$QyqFHA.3444@TK2MSFTNGP12.phx.gbl...
> see the Excel VBA help on the Application.International function.
>
> --
> Regards,
> Tom Ogilvy
>
> "DS NTE" <sorry@no.email> wrote in message
> news:eQ6s7$xqFHA.4072@TK2MSFTNGP09.phx.gbl...
>> How can I determine witch language excel "uses"?
>> My problem is that som users have an english version and some users have
> an
>> norwegian version. This causes problems when working with commandbars:
>>
>> Norwegian: Set CmdBarMenu = CmdBar.Controls("Verktøy")
>> English: Set CmdBarMenu = CmdBar.Controls("Tools")
>>
>> Is there a global method of doing this so this language issue wont cause
> me
>> any trouble?
>>
>>
>> knut
>>
>>
>>
>>
>
>