- Amazon Student members save an additional 10% on Textbooks with promo code TEXTBOOK10. Enter code TEXTBOOK10 at checkout. Here's how (restrictions apply)
Mastering VBA for Office 2010 Paperback – Aug 24 2010
There is a newer edition of this item:
Special Offers and Product Promotions
Frequently Bought Together
Customers Who Bought This Item Also Bought
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your e-mail address or mobile phone number.
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.
Inside This Book(Learn More)
What Other Items Do Customers Buy After Viewing This Item?
Most Helpful Customer Reviews on Amazon.com (beta)
BUT-- here's an idea. GET THIS BOOK INSTEAD. It covers all the Office applications, and by the time you've scanned it, you'll have a really good feel for the whole field of VB as applied to customizing office tools. THEN, if, for example, you want to know how to script or record a macro that will convert hyperlinks to end notes in Word, just Google that phrase, and use this reference/text to figure out what the web is telling you to do for that specific task.
With Windows 8 coming out and Office 2013 to 2020 etc., it this a good time to buy this book? An unqualified YES. The VB code and macro recording info are backward compatible to 07 and forward compatible indefinitely. Why? Because the script IS script, and Microsoft has made a 20 year commitment to OOP, including both C# and VB. They are still writing their programs in both as we speak! I'm a developer on the search side of C#, and all their advanced info shows a continuing commitment to both platforms, so don't fret the usual out of date before it's printed routine (although you are smart to wonder about it!).
Very well contented and indexed, so you can use it both as a study guide and reference. There are other books that give general info on VB and are better for learning the language from the ground up, but even beginners will find this easy to use for specific tool creation, because the authors assume you're looking for specialized applications and macros, not a general education in VB. That said, what better way to learn a language than actually creating tools right off the bat with it?? Will save you time surfing, money on more expensive books, and be a lot of fun seeing how to make many tasks a lot easier in Office, the way professional application developers do, but without needing years of background to do it.
If you're new to scripting, you should also realize that Visual Basic and VBA are different in that VBA is a specific subset of VB written primarily for developing custom APPLICATIONS (the "A") for Office. This is a good thing, because you'll also learn both macros and the VB underneath them. Usually (not always), there are simple ways to execute tasks with macros alone, and in those cases you won't have to use VBA, as it will be running in the background. This book DOES attempt to use Office tools to teach you VBA specifically (and a lot of VB along with it), and does a great job in doing so, whether you're a seasoned developer and macro writer, or just really good at Word and Excel and wanting to expand your ability to automate tasks and customize mini applications, or even create your own plug ins.
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.
The language is excellent -i.e. not too technical.
Print and layout makes for easy reading.
IT lays out VBA for all the Microsoft Office applications and clearly defines each task to be done.
There is some reading to be done but it is excellently interspersed with small tasks.
One criticism is that the font size is too small. To make it larger would make the 'tome' too unwieldy. This criticism is more to do with my age I think! I have a magnifying glass close at hand.
Look for similar items by category
- Books > Computers & Technology > Microsoft > Applications > Office
- Books > Computers & Technology > Microsoft > Development > VBA
- Books > Computers & Technology > Microsoft > Development > Visual Basic
- Books > Computers & Technology > Programming > Software Design, Testing & Engineering > Software Development
- Books > Textbooks