9780470634004

Mastering Vba for Office 2010

by
  • ISBN13:

    9780470634004

  • ISBN10:

    0470634006

  • Edition: 2nd
  • Format: Paperback
  • Copyright: 8/24/2010
  • Publisher: Sybex

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $49.99 Save up to $16.40
  • Rent Book $44.99
    Add to Cart Free Shipping

    TERM
    PRICE
    DUE

Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The Rental copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Summary

Office 2010 brings profound, new ways to extend its applications with VBA programming. This book covers the basics of VBA in clear, systematic tutorials and includes intermediate and advanced content for experienced VB developers. It addresses not just one Office application, but the whole Office suite. Further, all of the content is anchored with solid, real-world projects in Word, Excel, Outlook, PowerPoint, and Access. Topics include recording macros and getting started with VBA; learning how to work with VBA; 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.

Author Biography

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.

Table of Contents

Recording Macros and Getting Started with VBA
Recording and Running Macros in the Microsoft Office Applications
Getting Started with the Visual Basic Editor
Editing Recorded Macros
Creating Code from Scratch in the Visual Basic Editor
Learning How to Work with VBA
Understanding the Essentials of VBA Syntax
Working with Variables, Constants, and Enumerations
Using Array Variables
Finding the Objects, Methods, and Properties You Need
Making Decisions and Using Loops and Functions
Using Built-In Functions
Creating Your Own Functions
Making Decisions in Your Code
Using Loops to Repeat Actions
Using Message Boxes, Input Boxes, and Dialog Boxes
Getting User Input with Message Boxes and Input Boxes
Creating Simple Custom Dialog Boxes
Creating Complex Dialog Boxes
Creating Effective Code
Building Modular Code and Using Classes
Debugging Your Code and Handling Errors
Building Well-Behaved Code
Securing Your Code with VBA's Security Features
Programming the Office Applications
Understanding the Word Object Model and Key Objects
Working with Widely Used Objects in Word
Understanding the Excel Object Model and Key Objects
Working with Widely Used Objects in Excel
Understanding the PowerPoint Object Model and Key Objects
Working with Shapes and Running Slide Shows
Understanding the Outlook Object Model and Key Objects
Working with Events in Outlook
Understanding the Access Object Model and Key Objects
Manipulating the Data in an Access Database via VBA
Accessing One Application from Another Application
Programming the Office 2010 Ribbon
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review