Mastering VBA for Microsoft Office 2007 [Paperback]

Richard Mansfield (Author)

Book Description

ISBN-10: 0470279591 | ISBN-13: 978-0470279595 | Publication Date: April 28, 2008 | Edition: 2

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'sVisual Basic 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, PowerPoint, Outlook, and Access. Includes pages of real-world examples and techniques.

Editorial Reviews

From the Back Cover

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'sVisual Basic® 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®, PowerPoint®, Outlook®, and Access®. 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.

Coverage includes:

• 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

• Modifying the Ribbon with XML code and callbacks

• Building, debugging, and securing your code

• 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

About the Author

Richard Mansfield is the author of more than 40 computer books, including CSS Web Design For Dummies (Wiley), Office 2003 Application Development All-in-One Desk Reference For Dummies (Wiley), Visual Basic .NET Power Tools (Sybex), and others. He is the former editor of COMPUTE! magazine and has written hundreds of magazine articles and two long-running columns.

Product Details

• Paperback: 888 pages
• Publisher: Sybex; 2 edition (April 28, 2008)
• Language: English
• ISBN-10: 0470279591
• ISBN-13: 978-0470279595
• Product Dimensions: 9.2 x 7.4 x 1.9 inches
• Shipping Weight: 2.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (15 customer reviews)
• Amazon Best Sellers Rank: #82,587 in Books (See Top 100 in Books)
  • #17 in Books > Computers & Technology > Microsoft > Development > VBA
  • #41 in Books > Computers & Technology > Microsoft > Development > Visual Basic

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

17 of 17 people found the following review helpful:

5.0 out of 5 stars The Best VBA Book, December 15, 2009

By 

K. Ma (London & Los Angeles) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Mastering VBA for Microsoft Office 2007 (Paperback)

I have bought two other VBA books before this one. I am very happy with this book and will say this is the best VBA book out there. The book starts with the VBA environment. How the components (modules, projects, subclass, etc) constitue to the whole programming environment and relate to the office environment.Then it gives you the concept of object oriented programming. Then how this concept determines the coding syntax and how it interacts with the 'objects' from the office software. Then it goes into detail of how to write codes base on the teaching from the prior chapters to work on the objects (spreadsheets, range, cells, tables, forms, graphics,...) which you want to achieve the results or perform functions/calculations on.

Unlike other books that skip the basics and jump straight into performing tricky codings to perform fancy result, this book first gives you a great foundation to fully comprehend the VBA environment. It is a very organized book, and very easy to follow. If you follow the structure of the book and write sample codes according to the book instructions, you will learn VBA very easily and quickly. I strongly recommand this book!

14 of 15 people found the following review helpful:

4.0 out of 5 stars A useful book, October 2, 2008

By 

Robert G. Shurtleff "profbob" (Colorado Springs) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Mastering VBA for Microsoft Office 2007 (Paperback)

I have been away from programming for about 10 years so I feel like a beginner in many respects. I had a need to automate the creation of some templates that I use frequently, but needed some help. This book was a good source for that help. I was able to find all the information that I needed, but it occasionally did require some searching. In a few cases, the information was not where I expected, but it was there. Like Microsoft's online help, each topic would benefit from a short example of the use of a particular command, but this might just be an indication of how much I have forgotten.

4 of 4 people found the following review helpful:

4.0 out of 5 stars Good for beginners., June 7, 2010

By 

Anthony J. Grisafi (New York, New York) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Mastering VBA for Microsoft Office 2007 (Paperback)

A good first book for beginners. Not enough information on the MS Office application object models to be an actionable resource, though. Plan on doing a lot of on-the-spot research when you actually sit down to write your first few scripts. I went ahead and got a second, more advanced, shorter book which considers the specific types of programs I will be writing after completing this.

I have recommended or loaned out the book to everyone who has approached me about learning to write macros.