Visual Basic for Applications (VBA) and the Visual Basic Editor (VBE) have provided the programmability environment for power users and developers alike in the Office applications for many years. VBA remains a constant in Office 2010 and this module will help you get started with these tools if you have never used them before. And may give some new ideas to others for how to work with data, extend the UI or automate processes using these core Office assets.
Hands-On Labs
Core Office Development Lab
The objective of this Hands-On Lab is to show that by combining the power and flexibility of core Microsoft Office application capabilities with a little bit of programming it is possible to develop solutions quickly and easily. In this HOL you will receive an introduction to Office development using Visual Basic for Applications (VBA) for working with data in Excel, document composition in Word and more.
Videos
Working with Data in Office
In this video you will learn about the native support for connecting to external data using core Office tools. And you will see how to easily consume and use this data in Excel.
Writing Visual Basic for Applications Code
There are a number of tools one can use for building solutions for Office and Visual Basic for Applications (VBA) has been among them for many years. VBA and the built-in Visual Basic Editor (VBE) are the core Office development environment. This video provides an introduction to VBA and writing code.
Core UI Customization
This video discusses how you can make UI customizations, e.g. ribben customizations, creating user forms in the VBE or adding embedded ActiveX controls on the surface of a document, by using the core Office tools.