Migrating VBA Applications from Office 2002 to Office 2007
Find Migration from Office 2002 - VOB Word Doc Application for Office 2007.
Issues: Although Office 2007 supports VBA application - VB macro code, menu bars are not displayed. Indeed, the VBA Macro Menus appears under the add-ons.
During my research, I realized that Office 2007 supports XML feed. Is there any ideal approach for porting a VBA Macro application to Office 2007?
Your best bet would be two MSDN articles, Customizing the 2007 Fluent Ribbon and Creating a Custom Tab Using XML Ribbon Ribbon , although they look like they are focused on doing this across all applications, not just one. There's help documents for each Office application to get them to try this Google query: site: msdn.microsoft.com office 2007 add a button to the ribbon .
This snippet, starting with the first link, should be what you are looking for:
What about existing solutions?
In previous versions of Office, developers used the Command Line Object Model to create Visual Basic code that changed the Fluent UI. In the 2007 Office release, this legacy code continues to work in most cases unchanged. However, changes made to toolbars in Microsoft Office 2003 now appear on the Add-Ins tab. The type of customization you customize depends on the original design of the add-in. For example, Office creates a menu command group that contains items added to the previous menu structure (such as the File menu, Insert menu, and Tools menu). Office also creates a toolbar command group that contains items added to previous built-in toolbars (for example, Standard toolbar,Formatting and Image toolbar) In addition, custom toolbars added by an add-in or document appear in the Custom Toolbars group on the Add-Ins tab.
a source to share