Using Open XML Package Editor to Create a Ribbon Button that runs a VBA Function
Sometimes an end-to-end solution requires some level of customization in the operation of a word-processing document or a spreadsheet. Of course, this is where VBA can be useful. Sometimes the best solution requires a combination of developer techniques, including Open XML, VBA or VSTO, SharePoint, and/or other tools. In this screen-cast, I walk through the simplest way to customize the ribbon (using the Open XML Package Editor PowerTool for Visual Studio 2010) and create a button on the ribbon that calls a VBA function.
In a subsequent screen-cast, I’ll show how to create a VBA add-in using the Open XML Package Editor, and in a third screen-cast, I’ll show how you can integrate VBA code with Open XML code to create a business application that uses Excel tables to provide interesting functionality.