Excel 2007 VBA Macro Programming
 |
Excel 2007 VBA Macro Programming |
Sep 2009 | English | ISBN-13: 978-0-07-162700-9 | 415 Pages | PDF | 6.02 MB
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
Download:
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
Download:
.png)
.png)
.png)
