Overview

This book helps you get more done in less time by automating Office tasks. Even if you're not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft's Visual Basic[registered] for Applications (VBA) and the in-depth instruction in this comprehensive guide. You'll jump right into the basics of recording and running macros with Office's built-in Macro Recorder, before quickly moving to the essentials of VBA syntax, using loops and functions, building effective code, and programming applications in Word, Excel[registered], PowerPoint[registered], Outlook[registered], and Access[registered]. You'll find pages of real-world examples as well as easy-to-follow techniques for topics such as accessing one application from another, programming the Ribbon, and much more. This book discusses such subjects as: understanding the essentials of VBA syntax; using the Macro Recorder in Word and Excel; creating code from scratch with the Visual Basic Editor; finding the objects, methods, and properties you need; using loops to repeat actions in your code and adding If statements for flexibility; adding more choices with message, input, and dynamic dialog boxes; and, modifying the Ribbon with XML code and callbacks Building, debugging, and securing your code. It helps you to: use VBA to customize your Office 2007 applications; transform complex operations into a single keystroke work with XML-based Files, the Ribbon, and ActiveX; add embedded macros and add-ins to improve productivity reinforce your skills with real-world examples.

Full Product Details

9786611382124

Table of Contents

Reviews

Author Information

Tab Content 6

Customer Reviews

Recent Reviews

Countries Available