Contents at a Glance

Introduction xvii

Part 1 • Introduction to Excel Development 1

Chapter 1 • Excel as a Development Platform 3

Chapter 2 • Getting to Know Your Environment 11

Chapter 3 • Getting Started with VBA 33

Chapter 4 • Debugging Tactics that Work 65

Part 2 • Mastering the Excel Object Model 85

Chapter 5 • Exploring the Application Object 87

Chapter 6 • Working with the Workbook Object 109

Chapter 7 • Winning with Worksheets 133

Chapter 8 • The Most Important Object 153

Chapter 9 • Practical Range Operations 181

Chapter 10 • Exploring Other Excel Objects 205

Part 3 • Advanced Excel Programming Techniques 233

Chapter 11 • Developing Class Modules 235

Chapter 12 • Adding User Personalization to Your Application 259

Chapter 13 • Excel Development Best Practices 281

Part 4 • Working with External Data 299

Chapter 14 • Integrating with Other Applications 301

Chapter 15 • Incorporating Text Files in Your Solution 321

viii contents at a glance

Chapter 16 • Dealing with Databases 349

Part 5 • Enhancing the End User Experience 409

Chapter 18 • Basic User Interfaces 411

Chapter 19 • Taking Control of Command Bars 435

Chapter 20 • User Form Construction 463

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

Chapter 22 • Application Deployment Strategies 529

Index 557

0 0

Post a comment