« The Opportunity Cost of Fireworks
Navipane Update »

Menu in the ribbon with different languages

7th July 2007, 11:09 am by Ron de Bruin

Hi all

I think we all struggle with the new ribbon in Office 2007.
But there is no way back and we have to deal with it if we want it or not.

A few months ago I add a ribbon page on my site and now start with looking for a good
way to make a menu that automatic change the labels in the language of the Excel version.

I add this page to my site with three example workbooks.
http://www.rondebruin.nl/dynamic.htm

Please give comments (good or bad)
It is new for me also so I can use extra brains from the readers of this blog.

Thanks

Ron de Bruin
http://www.rondebruin.nl/tips.htm

Category: Excel12  |  Comment (RSS)  |  Trackback

11 Comments

  1. doco:

    [blockquote]
    But there is no way back and we have to deal with it if we want it or not.
    [\blockquote]

    I have Office 2007 Enterprise ready to install. I was told 12 still had a ‘a lot of bugs’ and ‘hold off loading until the service pack’ comes out. I have not loaded it - is this something to yet be of concern?

    9 July 2007, 6:03 am

  2. Jon Peltier:

    Doco -

    There have been no fixes released yet that address this kind of issue in Office 2007. What you have to do is install 2007 on a test computer, and examine its treatment of all of your critical documents, workbooks, VBA procedures, etc. If the new behavior is acceptable to you, then you may decide to deploy Office 2007. I can’t answer for you, because I don’t know what is critical to you, and I have certain issues which may not be relevant to your requirements.

    9 July 2007, 7:16 am

  3. papabear:

    Why not keep them both? On my machine I have both 2003 and 2007 living happily together. The only choice you have to make is between outlook 2003 and 2007. I think you can safly choose 2007 there.

    10 July 2007, 1:16 am

  4. Harald Staff:

    Do not upgrade Outlook if you write software, for others, that use the Outlook object model and need it to be compatible with previous versions.

    This said, Outlook downgrades surprisingly well; uninstall 2007 and reinstall 200X and everything will probably work as always without any additional effort. (Been there, done that).

    10 July 2007, 7:04 am

  5. doco:

    Thanks. I definitely am not interested having multiple versions. I develop things for my own use and within the local ‘enterprise’ and have about ten years of tools, functions, add-ins, etc. in SQL Server,Access and Excel particularly Most of which are fairly critical to what I do. I am dreading to think I will need to recreate thousands of hours of effort…

    10 July 2007, 9:49 am

  6. Jim Rech:

    Hi Ron-

    I haven’t had to handle multiple languages but I have had to change button labels to suit various clients. Using a table and getLabel (as in your GetLabel.xlsm)is such a natural for Excel developers I don’t think I even considered any other way.

    Do you like using dynamic menus? I find building all that xml in a VB module a bit of a pain. I think I get all the flexibility I need with a static menu and getLabel and getVisible.

    13 July 2007, 7:51 am

  7. Ron de Bruin:

    Hi Jim

    >Do you like using dynamic menus?

    I agree that getlabel is great but what if we want to do it for Word or PowerPoint.
    we not have a Excel sheet where we can add a table.

    Maybe a dynamic is a better option in that situation ?

    Thanks

    13 July 2007, 10:41 am

  8. Jim Rech:

    >>Maybe a dynamic is a better option in that situation?

    I’m not sure, Ron, perhaps. Some Select Case routines might be almost as good as an Excel table though.

    13 July 2007, 3:59 pm

  9. Ron de Bruin:

    Hi Jim

    Maybe you are right.
    I test a few things when I have vacation(more time).

    Thanks for your reply

    13 July 2007, 10:30 pm

  10. Jon Peltier:

    Jim, Ron -

    How about a CSV file? You can read that easily in VBA, then use Split to extract the “cell” values.

    I even use this instead of an Excel worksheet in many of my projects if all I’m saving is a bunch of settings.

    14 July 2007, 8:32 am

  11. Ron de Bruin:

    Hi Jon

    That’s also a good suggestion.

    15 July 2007, 1:02 pm

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment