Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Mastering VBA for Office 2010 [Paperback]

Richard Mansfield

List Price: CDN$ 59.99
Price: CDN$ 30.00 & FREE Shipping. Details
You Save: CDN$ 29.99 (50%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 3 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Tuesday, April 22? Choose One-Day Shipping at checkout.

Book Description

Aug. 24 2010
A comprehensive guide to the language used to customize Microsoft Office

Visual Basic for Applications (VBA) is the language used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. This complete guide shows both IT professionals and novice developers how to master VBA in order to customize the entire Office suite for specific business needs.

  • Office 2010 is the leading productivity suite, and the VBA language enables customizations of all the Office programs; this complete guide gives both novice and experienced programmers the knowledge they need to make maximum use of VBA for Office
  • Supported with real-world examples in Word, Excel, PowerPoint, Outlook, and Access, this book offers clear, systematic tutorials with both intermediate and advanced content
  • Covers learning how to work with VBA; recording macros; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files; ActiveX; the developer tab; content controls; add-ins; embedded macros; and security

Mastering VBA for Office 2010 prepares developers to customize all Microsoft Office 2010 applications for the unique needs of their employers.


Frequently Bought Together

Mastering VBA for Office 2010 + Access 2010 Programmer's Reference + Microsoft Access 2010 VBA Macro Programming
Price For All Three: CDN$ 83.30

Show availability and shipping details

  • In Stock.
    Ships from and sold by Amazon.ca.
    FREE Shipping. Details

  • Access 2010 Programmer's Reference CDN$ 27.00

    In Stock.
    Ships from and sold by Amazon.ca.
    FREE Shipping. Details

  • Microsoft Access 2010 VBA Macro Programming CDN$ 26.30

    In Stock.
    Ships from and sold by Amazon.ca.
    FREE Shipping. Details


Customers Who Bought This Item Also Bought


Product Details


Product Description

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.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.5 out of 5 stars  17 reviews
24 of 26 people found the following review helpful
5.0 out of 5 stars Amazing for the Price and NOT dated Aug. 31 2012
By Let's Compare Options - Published on Amazon.com
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. 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.
14 of 16 people found the following review helpful
5.0 out of 5 stars Easy to understand July 13 2011
By The Vanishing Turkey - Published on Amazon.com
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.
10 of 11 people found the following review helpful
3.0 out of 5 stars More for the knowledgeable than the newbie Jan. 19 2013
By Edward J. Zellner - Published on Amazon.com
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.
8 of 9 people found the following review helpful
4.0 out of 5 stars VBA Basics Dec 21 2012
By ERIK VAHL MEYER - Published on Amazon.com
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.
3 of 3 people found the following review helpful
5.0 out of 5 stars Great reference book Dec 17 2012
By Rodney R. Gay - Published on Amazon.com
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.
ARRAY(0xabc6fba4)

Look for similar items by category


Feedback