Excel 2007 VBA Macro Programming, 2nd Edition

Excel 2007 VBA Macro Programming, 2nd Edition

416 pages | McGraw-Hill Osborne Media; 2 edition (September 3, 2009) | ISBN: 0071627006 | PDF | 7.5 MB

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

Download from RapidShare

http://rapidshare.com/files/311977536/McGraw-Hill_-_Excel_2007_VBA_Macro_Programming__2009_.rar

in - All - Music Audio Books Sound Clips Movies Music videos TV Shows Windows MacOS Unix/Linux PC Mac Graphics Scripts&Template All In One