VBA for Office developers

Microsoft Office applications offer a very rich set of features, and provide many different ways to author, format, and do things with documents, email, databases, spreadsheets, and presentations. These features are extensible, meaning that the operations that you perform using the mouse, keyboard, and dialogs can also be performed by simple Visual Basic for Applications (VBA) code scripts.

You can create VBA code scripts behind Office applications or behind documents. You can write code from scratch, or you can set applications such as Word or Excel to record your mouse-clicks and generate the code for you. Using VBA you can create code that automates repetitive tasks and simplifies a complex series of clicks and keystrokes.

Books

Mastering VBA for Office 2010 By Richard Mansfield Office VBA Macros You Can Use Today: Over 100 Amazing Ways to Automate Word, Excel, PowerPoint, Outlook, and Access

Access 2010 VBA Programming Inside Out By Andrew Couch Excel 2010 Power Programming with VBA By John Walkenbach

Excel 2007 VBA Macro Programming By Richard Shepherd Word 2007 Macros & VBA Made Easy By Guy Hart-Davis more

By product

Office cross-application

VBA support