|
Pro Excel 2007 VBA
Pro Excel 2007 VBA is a professionals' guide to understanding and implementing the key principles and techniques of programming Microsoft Office Excel 2007. Automating complex spreadsheets, streamlining time-intensive work processes, gaining the competitive edge, and making more money for your businesses: these are all reasons to take Excel to the
next level. This book teaches how to do just that, with Jim DeMarco using his own real-life experience to develop your understanding to this professional level. The text dives right into teaching the most efficient way to create complex and feature rich VBA code, exposing all the new features and capabilities that make Excel 2007 such an exciting edition to work with.
CONTENTS:
This is a HIGH-LEVEL table of contents, keeping to the level of chapter titles:
Introduction -
What is in this book?
What's new for developers?
Brief explanation of advanced concepts
Excel 2007 object model and XML format changes
Chapter 1 - The Macro Recorder and Code Modules
Macro Security
Macro Recorder
Standard Modules
Class Modules
Brief over view of OOP
Why bother with OOP?
Chapter 2 - Data In, Data Out
Chapter 3 - Using XML in Excel 2007
Chapter 4 - User Forms
Chapter 5 - Charting
Chapter 6 - Pivot Tables
Chapter 7 - Debugging and Error Handling
Chapter 8 - Integrating with Office 2007
Chapter 9 - Infopath
Chapter 10 - Using Compiled Code in Excel 2007
COM Integration
.NET Integration
|
