Excel 2007 VBA Macro Programming

by Richard Shepherd

Subject categories
ISBNs
  • 0071627014
  • 9780071627009
  • 9780071627016

Develop custom Excel VBA macros

Perfect for power users, this practical resource reveals how to maximize the features and functionality of Excel 2007. You'll get in-depth details on Excel VBA programming and application development followed by 21 real-world projects--complete with source code--that show you how to set up specific subroutines and functions. The book then explains how to include the subroutines in the Excel menu system and transform a set of interrelated VBA macros into an Excel add-in package. Create your own Excel 2007 VBA macros right away with help from this hands-on guide.

Excel 2007 VBA Macro Programming shows you how to:

  • Write and debug VBA code
  • Create custom dialog boxes and buttons
  • Maximize the Excel object model
  • Write code to interact with a database
  • Add functionality to your programs with API calls
  • Insert class modules
  • Develop custom menus for the Ribbon
  • Animate objects in Excel
  • Create and manipulate Pivot Tables in VBA
  • Expand calculation and search functions
  • Create full-fledged Excel add-ins
  • Use VBA to work with XML files

  • McGraw-Hill Education; November 2009
  • ISBN: 9780071627016
  • Edition: 1
  • Read online, or download in secure PDF or secure ePub format
  • Title: Excel 2007 VBA Macro Programming
  • Author: Richard Shepherd
  • Imprint: McGraw-Hill Education
Subject categories
ISBNs
  • 0071627014
  • 9780071627009
  • 9780071627016

About The Author

Richard Shepherd is a qualified accountant who has spent the last 20 years developing computer software in blue-chip organizations. He is the author of the previous edition of this book.