Determine excel language

D

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
 
B

Bob Phillips

Use the Toolbar Id


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

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting URLs in comments to Markdown-formatted links 2
Get the right language when inserting a date 2
Office 2007 display language problems 0
Default Language 0
Changing language in reference tool 1
How to get the available languages (MUI) of Excel using VBA? 0
Easy way for the user to change Office 2007 display language? 2
Language problem using Outlook Add-In 8

Top