Mastering VBA for Microsoft Office 2007 covers the basics of the language in clear, systematic tutorials, and includes intermediate and advanced content for experienced VB developers. Unlike the competition, which addresses just one Office application, this book covers the whole Office suite. Further, all of the content is anchored with solid, real-world projects in Word, Excel, Outlook, PowerPoint, and Access. Office 2007 brings profound new features to VBA programming, including
the replacement of menus by the Ribbon
Quick Access Toolbar
dialog box launcher
Office button
the new keyboard shortcuts
the new Access Navigation pane
new macro filename extensions
all of which are thoroughly covered in this book.
Topics include recording macros and getting started with VBA; learning how to work with VBA; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files, ActiveX, the developer tab, content controls, add-ins, embedded macros, and security.
