The Office 2007 Automation Story
When you want to create macros to save yourself time while working in Word, Excel, or PowerPoint, use VBA. To add macros for any purpose to the Ribbon, or to customize the Ribbon in other ways (such as creating a tab with some of your favorite features), use XML. VBA or XML can be used, depending on the specific functionality you need, to automate actions in your documents. And, the two can be used together to create add-ins for Word, Excel, or PowerPoint.
In the next chapter, learn the basics of VBA programming. Following that, get the essentials of Office Open XML, including how to edit Office Open XML Format files directly in the XML, how to bind data to Word Content Controls, and the basics of how to customize ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access