Sample Download : http://code.msdn.microsoft.com/VBOfficeRibbonAccessibility-8d3c37fd
This example illustrates how to pinvoke the Microsoft Active Accessibilty (MSAA) API to automate Office Ribbon controls. The code calls the following APIs, AccessibleObjectFromWindow, AccessibleChildren, GetRoleText, GetStateText,to display the whole structure of the Office ribbon, including tabs, groups, and controls. It also shows how to nagivate to a tab and execute button function programmatically..
You can find more code samples that demonstrate the most typical programming scenarios by using Microsoft All-In-One Code Framework Sample Browser or Sample Browser Visual Studio extension. They give you the flexibility to search samples, download samples on demand, manage the downloaded samples in a centralized place, and automatically be notified about sample updates. If it is the first time that you hear about Microsoft All-In-One Code Framework, please watch the introduction video on Microsoft Showcase, or read the introduction on our homepage http://1code.codeplex.com/.