Book description
Pro Excel 2007 VBA is the complete guide to creating Excel VBA applications, including coverage of new features in Excel 2007. Covering object-oriented programming techniques, debugging, and error handling methodologies, this book quickly turns novice into expert as it explores COM and .NET components and the advantages of compiled code. The book also covers XML for Excel web development.
This book is unique insomuch that author Jim DeMarco is a true expert in the field of Excel programming, and he conveys the Visual Basic for Applications story in the context of the real world. Not just another dry programming guide, Pro Excel 2007 VBA is a journey from novice to expert where the author is your traveling companion. Bon voyage!
Table of contents
- Title Page
- Dedication
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- CHAPTER 1: The Macro Recorder and Code Modules
- CHAPTER 2: Data In, Data Out
- CHAPTER 3: Using XML in Excel 2007
- CHAPTER 4: UserForms
- CHAPTER 5: Charting in Excel 2007
- CHAPTER 6: PivotTables
- CHAPTER 7: Debugging and Error Handling
- CHAPTER 8: Office Integration
- CHAPTER 9: ActiveX and .NET
- Index
Product information
- Title: Pro Excel 2007 VBA
- Author(s):
- Release date: March 2008
- Publisher(s): Apress
- ISBN: 9781590599570
You might also like
book
Beginning Access™ 2007 VBA
This book provides you with the tools and techniques you'll need in order to build more …
book
Excel 2007 VBA Programming with XML and ASP
Excel 2007 Programming by Example with XML and ASP offers a hands-on approach for those looking …
book
Access™ 2007 VBA Programmer's Reference
This resource provides the tools you need to leverage Access 2007's built-in functionality and VBA in …
book
Excel® 2007 VBA Programmer's Reference
Get ready to take your Excel applications to the next level by harnessing the power of …