Shepherd R. - Excel 2007 VBA Macro Programming, 2nd Edition [2009, PDF, ENG]

Книги и журналы » Компьютерная литература » Программы от Microsoft

Excel 2007 VBA Macro Programming, 2nd Edition

Год выпуска: 2009
Автор: Richard Shepherd
Издательство: McGraw-Hill
ISBN: 0071627006
Формат: PDF
Качество: eBook (изначально компьютерное)
Количество страниц: 416
Описание: 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
[spoiler="Скриншоты"]





[/spoiler]