+ Reply to Thread
Results 1 to 5 of 5

Dynamic generation icon groups in ribbon 2007~

  1. #1
    Forum Contributor
    Join Date
    09-30-2009
    Location
    Barcelona
    MS-Off Ver
    Excel 2010
    Posts
    274

    Question Dynamic generation icon groups in ribbon 2007~

    Hello,

    I am migrating several excel-based tools from xl2003 to xl2007 and I am facing some issues with toolbars
    all the research I have done so far with the ribbon end up with an xml file that must be imported, often through add-ins and other manual means.
    Is there any way to generate icons and groups by code?

    I am interested in documentation of all the parameters attachable to controls of a given group in a tab.
    is there any resource that offers this information in an understandable way?

    I need to see how it works internally to make it work by code so I can describe the contents of a toolbar in a table for instance. This makes toolbar maintenance a breeze.

    Tank you!

  2. #2
    Forum Contributor
    Join Date
    09-30-2009
    Location
    Barcelona
    MS-Off Ver
    Excel 2010
    Posts
    274

    Re: Dynamic generation icon groups in ribbon 2007~

    We managed to do it

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Dynamic generation icon groups in ribbon 2007~

    Care to explain how you did it, if not the standard way via xml?
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    09-30-2009
    Location
    Barcelona
    MS-Off Ver
    Excel 2010
    Posts
    274

    Re: Dynamic generation icon groups in ribbon 2007~

    Well, we generate the XML file from a table and from there we do the usal process of importing the XML file into the customUI folder, modify RELS etc etc.
    We do not explore all the possibilities of the ribbon, but enough for us --

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Dynamic generation icon groups in ribbon 2007~

    Thanks for the explanation.
    I have used similar half and half approach to automate ribbon creation at design stage.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Ribbon Icon Size
    By PPatrick in forum Excel General
    Replies: 1
    Last Post: 09-14-2012, 07:22 PM
  2. Icon in Add-in menu XL2007 Ribbon
    By rwgrietveld in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2010, 07:19 PM
  3. Dynamic code Generation
    By Bazman2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-19-2009, 11:33 AM
  4. [SOLVED] Dynamic List Generation
    By wmureports in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2006, 04:25 PM
  5. Dynamic Chart Generation
    By jonwatts in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-15-2005, 10:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1