Get name or Id of a ribbon controls

Question

I have a custom ribbon control in my excel that ribbon is developed through 3rd party c# add in. How do I trigger a ribbon button click using VBA code? Many examples over the net show this but my first problem is I even don't know the name of the ribbon. How do I get the name of the ribbon and ribbon button i am interested in?

Answer 1

I found this below link How to get Ribbon custom Tabs IDs?

further reading reached me to this link

http://www.wordarticles.com/Shorts/RibbonVBA/RibbonVBADemo.php

In the download section I downloaded the word template that has a VBA program to read the ribbon,tab and buttons. It also has a code to trigger/ execute the selected button. This VBA function can also be used for excel.