Excel 2007 VBA Macro Programming

Excel 2007 VBA Macro Programming

<p><strong>Develop custom Excel VBA macros</strong></p><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. </p><p><em>Excel 2007 VBA Macro Programming</em> shows you how to:</p><ul><li><div>Write and debug VBA code </div></li><li>Create custom dialog boxes and buttons </li><li>Maximize the Excel object model </li><li>Write code to interact with a database </li><li>Add functionality to your programs with API calls</li><li>Insert class modules </li><li>Develop custom menus for the Ribbon</li><li>Animate objects in Excel</li><li>Create and manipulate Pivot Tables in VBA</li><li>Expand calculation and search functions </li><li>Create full-fledged Excel add-ins </li><li>Use VBA to work with XML files</li></ul>