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.
Nice video, but for ribbon customization I'll stick with Custom UI Editor Tool (openxmldeveloper.org/.../customuieditor.aspx). Great for adding the necessary part and images for my controls, not so great for editng xml. So I copy my xml to Visual Studio for editing. To get Intellisense, I installed the CustomUI.xsd (www.microsoft.com/.../details.aspx) in C:\Program Files\Microsoft Visual Studio 10.0\Xml\Schemas.
This is a real-world scenario - you need to implement some sophisticated manipulation of Excel tables
Hello
I am wondering which i the best way to add panning hand to Excel 2010 running Win 7 x64?
I had it & now its gone? If it was there at one point can be retrieved.