Mastering VBA for Office 2010 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Customers who viewed this item also viewed
Customers who bought this item also bought
From the Back Cover
Get more done in less time by automating Office tasks
Take control of Office 2010 with Microsoft's Visual Basic for Applications (VBA) and this practical guide. Even if you're not a programmer, you can easily learn to record and write macros, automate tasks, and create your own custom programs for Word, Excel, PowerPoint, Outlook, and Access.
You'll quickly grasp the basics of recording macros with Office 2010's built-in Macro Recorder, before delving into all the essentials: the Visual Basic Editor, VBA syntax, how to use loops and functions, the keys to building effective code, how to debug and secure your code, programming the Office 2010 Ribbon, and much more.
Recording, writing, and running macros in Office 2010
Creating code from scratch with the Visual Basic® Editor
Understanding the essentials of VBA syntax
Finding the objects, methods, and properties you need
Using loops to repeat actions in your code
Creating simple and complex dialog boxes
Adding If statements to make your applications respond intelligently
Programming each Office app―Word, Excel®, PowerPoint®, Outlook®, and Access®
Building, debugging, and securing your code
Use VBA to Increase Your Productivity in Office 2010
Simplify Complex Operations with Macros and Automation
Create Custom Apps for Word, Excel, PowerPoint, Outlook, and Access
Reinforce Your Skills with Real-World Examples
Master VBA Fundamentals and Essentials
Create Custom Applications and Macros for Office 2010
About the Author
Richard Mansfield is the author or coauthor of more than 40 computer books, includingVisual Basic .NET Power Toolkit, Office 2003 Application Development All-in-One Desk Reference For Dummies, and Programming: A Beginner's Guide. He is the former editor of Compute! magazine. Overall, his books have sold more than half a million copies worldwide and have been translated into 12 languages.
There was a problem filtering reviews right now. Please try again later.
From a presentation perspective the text sizes and examples are very small and can be difficult to read but the alternative is to create a book that could easily double in page count and cost. I believe that for this book it was worth my squinting a little more than usual. Some additional examples would also be helpful but how much can you honestly expect to be packed into a single book? Maybe a companion workbook would be a good suggestion for the author.
Richard Mansfield is the real deal when it comes to VBA knowledge but most importantly he delivers the learning experience with the proficiency and skill of a master teacher. He reassures you that if some of the material seems hard to conceptualize that you should not worry, and it will be made clear in later chapters. He understands that you are learning and cares enough to mentor you through the process. I learned that turning each page in succession provided me with much more understanding than I would achieve with my impatient shortcutting methods that I normally gravitate to. So as a bonus the author is helping me to learn how to learn.
My original plan for this book was to read it and then donate it to the library but after spending so much time with it I feel it has earned its place on my desk as a valuable and reliable reference. There is little glamour or financial reward in writing such technical manuals and the audience is much smaller than that of the entertainment novels, but the commitment to such an endeavor and to do it well is a tribute to the mastery and dedication of the author. I thank Mr. Mansfield for willing to take on such a project and at least in my case, helping someone to learn the craft the way it should be learned. If you are serious about learning VBA you owe it to yourself to buy this book.
This book provides a step-by-step description of what to do and how to do what I want. Much is familiar, but the minor differences are the 'killers', and this author walks us through the technical details very comfortably. For new things/techniques/concepts I have no trouble following him. Since I don't work with VB or VBA every day, I am confident that I can use this book as a detailed reference guide and reminder.
For beginners, this is an excellent starting point. For part-time users, this is an excellent resource. For me, the strength of the book is that when "I know what I want to do, but I don't know how to do it in VBA" the author has the answers accessible and explained such that I can either study the explanations and tutorials in detail, for what I want to do, or I can find the brief example that triggers my memory and allows me to get back to the macro/program.
For example, Object Methods and Properties. VBA doesn't have the extensive Intellisence options I'd like, but Chap. 8 tells us how to find the appropriate list of properties and methods via the Object Browser. Instead of guessing and experimenting to find the correct format and wording for specifying a particular property I now know how to look it up.
Who might not benefit from this book? Someone who codes VBA daily may know too much and not want to bother rehashing all of this basic info. For the rest of us, I give this book a 5-star rating.
If you are new to VBA I highly recommend this book.
Top international reviews
I would have preferred if it had worked through a project from start to full complexity but c'est la vie.