Excel 2007 VBA Macro Programming

Develop custom Excel VBA macrosPerfect 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 buttonsMaximize the Excel object modelWrite code to interact with a databaseAdd functionality to your programs with API callsInsert class modulesDevelop custom menus for the RibbonAnimate objects in ExcelCreate and manipulate Pivot Tables in VBAExpand calculation and search functionsCreate full-fledged Excel add-insUse VBA to work with XML files