Ribbon Control IDs through VBA or C# / .Net
Budget: $30 – $60 USD
Hi,
I need a VBA or .Net solution that loops through *all* of the Ribbon controls and add-ins and provides the control ID and label as output.
Trying to better control the user experience and how things are displayed. Consequently, need more than just the built-in IDs and, preferably, *only* the custom add-ins IDs and labels.
We do our best to review everyone that applies and to respond to all of those who have pertinent experience.
Please see sample materials below.
Thanks!
========================================
Sample Code Below
========================================
The code in the .txt file attached is VBA but does not compile because there is no IRibbonTab. The two snippets that are commented out are .Net-based.
The attached Word template that contains VBA file uses a Win32 approach from this article:
http://www.wordarticles.com/Shorts/RibbonVBA/RibbonVBADemo.php
but I had to add exception handling, etc. because it did not work and threw errors.
The code provided is *for reference only*. I do *not* care how this gets working. I simply need to pull all of the IDs, labels / tags of Ribbon Tabs, Tab Groups, and associated controls - *especially* of Excel add-ins. The built-in stuff can be ignored, honestly.
Hopefully, this can be helpful.
We would expect that someone who has done this before can complete this quickly; in a matter of hours. More work may come later.
Thank You.
I need a VBA or .Net solution that loops through *all* of the Ribbon controls and add-ins and provides the control ID and label as output.
Trying to better control the user experience and how things are displayed. Consequently, need more than just the built-in IDs and, preferably, *only* the custom add-ins IDs and labels.
We do our best to review everyone that applies and to respond to all of those who have pertinent experience.
Please see sample materials below.
Thanks!
========================================
Sample Code Below
========================================
The code in the .txt file attached is VBA but does not compile because there is no IRibbonTab. The two snippets that are commented out are .Net-based.
The attached Word template that contains VBA file uses a Win32 approach from this article:
http://www.wordarticles.com/Shorts/RibbonVBA/RibbonVBADemo.php
but I had to add exception handling, etc. because it did not work and threw errors.
The code provided is *for reference only*. I do *not* care how this gets working. I simply need to pull all of the IDs, labels / tags of Ribbon Tabs, Tab Groups, and associated controls - *especially* of Excel add-ins. The built-in stuff can be ignored, honestly.
Hopefully, this can be helpful.
We would expect that someone who has done this before can complete this quickly; in a matter of hours. More work may come later.
Thank You.