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
or
Get a £9.65 Amazon.co.uk Gift Card
Mastering VBA for Office 2010
 
 
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
3.7 out of 5 stars  See all reviews (3 customer reviews)
RRP: £33.99
Price: £22.09 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £11.90 (35%)
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
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.
Only 8 left in stock--order soon (more on the way).
Want guaranteed delivery by Saturday, June 2? Choose Express delivery at checkout. See Details
Trade In this Item for up to £9.65
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Mastering VBA for Office 2010 for an Amazon.co.uk gift card of up to £9.65, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.

Frequently Bought Together

Customers buy this book with Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) £22.09

Mastering VBA for Office 2010 + Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)
Price For Both: £44.18

Show availability and delivery details



Product details

  • Paperback: 912 pages
  • Publisher: John Wiley & Sons (20 Aug 2010)
  • Language English
  • ISBN-10: 0470634006
  • ISBN-13: 978-0470634004
  • Product Dimensions: 23.4 x 18.8 x 5 cm
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: 93,786 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Richard Mansfield
Discover books, learn about writers, and more.

Visit Amazon's Richard Mansfield Page

Product Description

Product Description

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.

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


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

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 

Your tags: Add your first tag
 

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

5 star
0
2 star
0
1 star
0
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
Good for new users 14 Nov 2010
Format:Paperback|Amazon Verified Purchase
This book is good for new users as it will take you through the basics and work with you as you become more expert.

I would have preferred if it had worked through a project from start to full complexity but c'est la vie.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
Macros & lack of VBA 30 Sep 2010
Format:Paperback
I have not ready many pages so far but i must admit that I was hoping for clear VBA examples. There appears to be a lack of Access. I hope the book will get better.
Comment | 
Was this review helpful to you?
Great book 31 May 2012
By Frank
Format:Paperback|Amazon Verified Purchase
I have not read cover to cover - I use this as a reference. It is fantastic - well layed out.
Comment | 
Was this review helpful to you?
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges