Access.2007.VBA.Bibl..

Part III Adding More Functionality to Office

Sources of Information on Customizing the Ribbon

T

he MSDN document “Customizing the Office (2007) Ribbon User Interface for Developers”

(Parts 1 through 3) is a very useful reference when creating Ribbon XML for Access (and other

Office applications).

The list of Control IDs (Access Ribbon Controls.xls) is invaluable for working with the Ribbon; it

lists the control, group, and tab names you need to use when creating Ribbon XML code. You can down-

load this worksheet from http://www.microsoft.com/downloads/details.aspx?family

id=4329d9e9-4d11-46a5-898d-23e4f331e9ae&displaylang=enon the Microsoft web site.

Several blogs are also valuable resources for information on working with the Ribbon in VBA or VB

code: In Erik Rucker’s blog, see the July 13, 2006 posting on Customizing the New Access UI for

information on customizing the Access Ribbon. The blogs maintained by Jensen Harris and Patrick

Schmid have lots of valuable information on Ribbon customization (Jensen Harris is the program

manager in charge of the Office UI team, and Patrick Schmid is an MVP). The Third of Five blog is

also useful. See the Office Developer Center web site for the latest list of Office-related blogs.

However, note that this worksheet was last updated in November 2006, and some of the names have

changed since then, so it is not entirely accurate, especially for group and tab names.

Here are links to the resources mentioned in the previous paragraph:

nCustomizing the Office (2007) Ribbon User Interface for Developers, Parts 1 through 3:

nhttp://msdn2.microsoft.com/en-us/library/ms406046.

aspx#OfficeCustomizingRibbonUIforDevelopers_AppLevel

nhttp://msdn2.microsoft.com/en-us/library/aa338199.aspx

nhttp://msdn2.microsoft.com/en-us/library/aa722523.aspx

nOffice 2007 Developer Center: http://msdn2.microsoft.com/en-us/office/

aa905358.aspx

nRibbon Extensibility in Access 2007: http://msdn2.microsoft.com/en-us/

library/bb187398.aspx

nTransitioning Your Existing Access Applications to Access 2007: http://msdn2.

microsoft.com/en-us/library/bb203849.aspx

nErik Rucker’s blog: http://blogs.msdn.com/access

nJensen Harris’ blog: http://blogs.msdn.com/jensenh/default.aspx

nPatrick Schmid’s blog: http://pschmid.net/blog/2006/10/09/58

nThird of Five Blog: http://blogs.msdn.com/thirdoffive/