Hi,

Please let me know, how to fire the click event of a Excel 2007 menu item programmatically in C#.

I have looped through the Menubars collection, Menu collections and MenuItems collections to identify the MenuItem of interest.

My requirement is to provide some specific buttons in my custom ribbon, which has identical behavior with some of Excel 2007 menu items.

I am using VST0 3.0 SP1 with .NET 3.5

Hi Anitra

Is this a CommandBarButton, or a button in the Ribbon? These are two quite different things, when it comes to the object model.

If, as you say, you've managed to "identify the Office.CommandBarButton", please show us how you are doing so. That will help us understand what it is we're dealing with.

If you have a CommandBarButton object, you should be able to use that object's Execute method to "click" it.

---

Cindy Meister, VSTO/Word MVP

Take a look at ExecuteMso API (http://msdn.microsoft.com/en-us/library/aa434602.aspx)
I am sure there is a lot of example on the web how this can be used.

---

Misha

Thanks for the reply.

In my case, its actually a 3rd party component button, whose click event I need to fire. So, I cant retrieve the IdMso.

I have also managed to identify the Office.CommandBarButton for the button whose click event I need ti trigger.

Is there some way, I can trigger the click event of the CommandBarButton which I have identified. I can find there are some methods: accDoDefaultAction.

Please let me know, how this can be achieved.

Hi Anitra

Is this a CommandBarButton, or a button in the Ribbon? These are two quite different things, when it comes to the object model.

If, as you say, you've managed to "identify the Office.CommandBarButton", please show us how you are doing so. That will help us understand what it is we're dealing with.

If you have a CommandBarButton object, you should be able to use that object's Execute method to "click" it.

---

Cindy Meister, VSTO/Word MVP

Thanks for the reply.

The Execute() method worked in my scenario