Shepherd R. Excel 2007 VBA Macro Programming

McGraw-Hill, 2010. - 386 p.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 filesProgramming in Excel VBA
The Basics
Variables, Arrays, Constants, and Data Types
Modules, Functions, and Subroutines
Programming Basics: Decisions and Looping
Strings and Functions and Message Boxes
Operators
Debugging
Errors and the Error Function
Dialogs
Common Dialog Control
Command Bars and Buttons
Object Models
The Excel Object Model
The Excel Object Model—Main Objects
Using Excel to Interact with Other Office Programs
Advanced Techniques in Excel VBA
Charts and Graphs
Working with Databases
API Calls
Class Modules
Animation
Working with XML Files
The Ribbon
Pivot Tables
VBA in Action
Converting Labels to Numbers and Numbers to Labels
Transposing a Range of Cells
Adding Formula Details into Comments
Calculating a Range
Reversing a Label
Who Created the Workbook?
Evaluating a Cell
Sorting Worksheets into Alphabetical Order
Replacing Characters in a String
Timed Events
Auto-Totaling a Matrix of Numbers
Absolute and Relative Formulas
Coloring Alternate Rows and Columns of the Spreadsheet
Coloring Cells Containing Formulas
Summing Cells by Reference to a Master Cell
Globally Changing a Range of Values
Displaying Hidden Sheets Without a Password
Searching Multiple Sheets and Workbooks
Brighten Up Your Comments
Importing a CSV File Containing Leading Zeros
Working with Shapes
Turning Your VBA Code into an Add-In