- Paperback: 912 pages
- Publisher: Sybex; 1 edition (August 24, 2010)
- Language: English
- ISBN-10: 0470634006
- ISBN-13: 978-0470634004
- Product Dimensions: 7.4 x 1.8 x 9.3 inches
- Shipping Weight: 2.9 pounds (View shipping rates and policies)
- Average Customer Review: 33 customer reviews
- Amazon Best Sellers Rank: #652,128 in Books (See Top 100 in Books)
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.
Mastering VBA for Office 2010 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
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 appWord, 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.
Top customer reviews
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.