Mastering Excel 2003 Programming with VBA (PME0005)

Mastering Excel 2003 Programming with VBA, Contens:

Part 1 • Introduction to Excel Development

Chapter 1 • Excel as a Development Platform

Chapter 2 • Getting to Know Your Environment

Chapter 3 • Getting Started with VBA

Chapter 4 • Debugging Tactics that Work

Part 2 • Mastering the Excel Object Model

Chapter 5 • Exploring the Application Object

Chapter 6 • Working with the Workbook Object

Chapter 7 • Winning with Worksheets

Chapter 8 • The Most Important Object

Chapter 9 • Practical Range Operations

Chapter 10 • Exploring Other Excel Objects

Part 3 • Advanced Excel Programming Techniques

Chapter 11 • Developing Class Modules

Chapter 12 • Adding User Personalization to Your Application

Chapter 13 • Excel Development Best Practices

Part 4 • Working with External Data

Chapter 14 • Integrating with Other Applications

Chapter 15 • Incorporating Text Files in Your Solution

Chapter 16 • Dealing with Databases

Chapter 17 • XL(M) = XML

Part 5 • Enhancing the End User Experience

Chapter 18 • Basic User Interfaces

Chapter 19 • Taking Control of Command Bars

Chapter 20 • User Form Construction

Chapter 21 • One Smart Cookie: Smart Documents with Excel 2003

Chapter 22 • Application Deployment Strategies

Password: D$R0fb2J