Programming Books C Java PHP Python Learn more Browse Programming Books
Buy New
$29.73
Qty:1
  • List Price: $49.99
  • Save: $20.26 (41%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $11.81
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Mastering VBA for Office 2010 Paperback – August 24, 2010

ISBN-13: 978-0470634004 ISBN-10: 0470634006 Edition: 1st

Buy New
Price: $29.73
32 New from $19.99 29 Used from $24.85
Amazon Price New from Used from
Paperback
"Please retry"
$29.73
$19.99 $24.85

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

Mastering VBA for Office 2010 + Excel 2010 Power Programming with VBA + 101 Ready-To-Use Excel Macros
Price for all three: $79.96

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 912 pages
  • Publisher: Sybex; 1 edition (August 24, 2010)
  • Language: English
  • ISBN-10: 0470634006
  • ISBN-13: 978-0470634004
  • Product Dimensions: 9.2 x 7.4 x 2 inches
  • Shipping Weight: 2.9 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (17 customer reviews)
  • Amazon Best Sellers Rank: #63,859 in Books (See Top 100 in Books)

Editorial Reviews

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.

Coverage includes:

  • 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.


More About the Author

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

Customer Reviews

4.5 out of 5 stars
5 star
11
4 star
3
3 star
3
2 star
0
1 star
0
See all 17 customer reviews
If you are serious about learning VBA you owe it to yourself to buy this book.
Tom G
This book contains a lot of material, by the time you work your way through it you will be a VBA programmer.
Rodney R. Gay
The VB code and macro recording info are backward compatible to 07 and forward compatible indefinitely.
Let's Compare Options

Most Helpful Customer Reviews

24 of 26 people found the following review helpful By Let's Compare Options TOP 500 REVIEWER on August 31, 2012
Format: Paperback Verified Purchase
What 1,000 page programming guide can you get new for under $30? OK, this covers ALL the office applications, and you might wonder if it would be better to learn macros and Visual Basic program by program. That depends on your needs. If all you ever do is Excel or Word, you could pay $30 or more for just ONE of those applications of macros/VBA, and get a LITTLE more depth in terms of specific examples.

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.
Read more ›
3 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
14 of 16 people found the following review helpful By The Vanishing Turkey on July 13, 2011
Format: Paperback Verified Purchase
I was a little apprehensive at first because programming books are often much more expensive than this but I am pleased with the information in it. The author does a great job of not only informing the reader of how to program, but what practices are useful in making programming easier. It is easy to see after each chapter that you are making progress, yet I felt I didn't have to wade through all that information. All in all, very happy with this book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
11 of 13 people found the following review helpful By Edward J. Zellner on January 19, 2013
Format: Paperback Verified Purchase
Being a newbie to VBA, I was trying to understand the structure of VBA and then move on to learning the specific commands. This book moves rapidly into commands and it left me wanting to understand the basics better. Although the editor in Office programs gives you hints as to what the appropriate sequences might be, it's still unclear to me. Even after creating many subroutines successfully, I still feel like I'm walking around in the dark. I kept hoping that I'd see the light once I did more of it but that's not the case. I do find myself referring to the book frequently but without web searches, I would have been unable to the work I needed successfully using only this book. There is a lot in the book in that it covers all office applications and is reasonably priced, however, that matters not if you can't get a solid understanding of the fundamentals. I'm looking for something better. It would be helpful to understand when some of the commands would be used and why. A single example is inadequate to really understand what a command can do.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 9 people found the following review helpful By ERIK VAHL MEYER on December 21, 2012
Format: Paperback Verified Purchase
It begins by assuming nothing so it is good from a novice or revision point of view.
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Rodney R. Gay on December 17, 2012
Format: Paperback Verified Purchase
This book contains a lot of material, by the time you work your way through it you will be a VBA programmer.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Tom G on September 8, 2013
Format: Paperback Verified Purchase
I had been writing my own VBA programs for Excel and was looking to learn more in that application. I was drawn to this book because it was one of the few that addressed the entire Microsoft Office suite; and at the same price as an Excel centric book I figured it would be a good investment. I began flipping through the book looking for quick examples that could get me going. Not finding what I was looking for my first impression was the book was more of a high level overview and not one that would give me the deep knowledge I was looking for. Was I ever wrong! I don't have much patience for reading a technical manual of this size but once I committed to reading from the front cover forward I quickly learned that this book was in fact the tool that I was searching for. The author painstakingly presents real world examples of VBA code and then describes each step with great clarity. You will learn good programming practices that make the user experience easier and of greater value. You will also gain a true appreciation for proper commenting and structure so that if in the future you or someone else has to modify the code it will be familiar and easy to do so.

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.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search

What Other Items Do Customers Buy After Viewing This Item?