Contents -- Introduction -- Part 1 Introduction to Excel Development -- Chapter 1 Excel as a Development Platform -- Who Develops in Excel? -- What Is an Excel Application? -- Why Use Excel? -- Stop When You See Red -- Summary -- Chapter 2 Getting to Know Your Environment -- One Exceptional Editor -- Managing Your Modules -- Optimizing Your Editor -- Helpful Editor Features -- Understated Features of the Code Window -- Object Inspection Using the Object Browser -- Obtaining Help Has Never Been So Easy -- Securing Your Project -- Quick Code Navigation -- Summary -- Chapter 3 Getting Started with VBA -- Thinking Like a Computer -- VBA Building Blocks -- Variables Are the Elements You Interact With -- Operators -- Directing Your Program with Statements -- Basic Array Usage -- Objects-A Human-Friendly Way to Think of Bits and Bytes -- Summary -- Chapter 4 Debugging Tactics that Work -- A Bug Epidemic -- Debugging Weapons in the VBE -- A Simple Debugging Methodology -- Implementing Simple Error Handling -- Summary -- Part 2 Mastering the Excel Object Model -- Chapter 5 Exploring the Application Object -- A Bird's-Eye View of the Application Object -- Display-Oriented Features You Have to Know -- Display-Oriented Features That Are Nice to know -- Convenient Excel Object Properties -- Common File Operations Simplified -- Inspecting Your Operating Environment -- Two Useful Bonus Members -- Summary -- Chapter 6 Working with the Workbook Object -- Walk before You Run: Opening and Closing Workbooks -- Is That Workbook Open? -- Untangle Links Programmatically (Part I) -- Plain Vanilla Workbook Properties -- Respond to User Actions with Events -- Summary -- Chapter 7 Winning with Worksheets -- Setting the Stage -- Validating Your Worksheets before Using Them -- Now You See It, Now You Don't -- Lock Up Your Valuables -- Managing Workbook Worksheets.

Expounding on Worksheet Events -- Summary -- Chapter 8 The Most Important Object -- Referring to Ranges -- Finding My Way -- Input Easy -- Output Easier -- Summary -- Chapter 9 Practical Range Operations -- Data Mobility with Cut, Copy, and Paste -- Find What You Are Seeking -- Don't Like It? Change It with Replace -- Would You Like Special Sauce with That? -- CurrentRegion: A Useful Shortcut -- Sorting Lists Simplified -- Summary -- Chapter 10 Exploring Other Excel Objects -- Make a Good First Impression -- Chart Manipulation -- Summary -- Part 3 Advanced Excel Programming Techniques -- Chapter 11 Developing Class Modules -- Class Modules Are for Creating Objects -- A Linguistic Foundation -- What's the Big Deal? Why Use Objects? -- Creating a Simple Object -- Using Your Object -- A Better, Smarter Object -- An Object Showdown -- Collecting Your Objects -- Implementing More Accurate Properties -- Summary -- Chapter 12 Adding User Personalization to Your Application -- The Need for Persistence -- Class Semi-Specification -- Planning the Plumbing -- Security Considerations -- The Setting Class -- Collect Those Setting Objects with Settings -- Pseudo? Says Who? -- Put Those Settings to Work -- Summary -- Chapter 13 Excel Development Best Practices -- Deactivate Activate -- Don't Select Select -- Manage the Display -- Design for Portability -- Test the Water before Jumping In -- Remember Your Math -- Think Like an Environmentalist -- Use Literal Values with Care -- Smart Workbook Design -- Summary -- Part 4 Working with External Data -- Chapter 14 Integrating with Other Applications -- A Primer to Office Automation -- Expounding On Compound Documents -- Crafting Compound Documents Programmatically -- OLE Is Great -- Automation Is Better -- Summary -- Chapter 15 Incorporating Text Files in Your Solution -- Versatile Simplicity.

Opening Text Files in Excel -- Importing Text Data onto a Worksheet -- Automatic Text Files -- The Old Standby-Copy/Paste -- Opening Files Under the Covers -- String Functions Offering Utility -- Summary -- Chapter 16 Dealing with Databases -- Database Basics -- Developing Your Skills -- Native Excel Database Integration -- Work Magic with ADO -- I Like Treats -- Summary -- Chapter 17 XL(M) = XML -- Y XML? -- XML in XL -- XML VBA Style -- A List Object Primer -- Summary -- Part 5 Enhancing the End User Experience -- Chapter 18 Basic User Interfaces -- User Interfaces in Excel -- Paleozoic Controls -- Like a Kid in a Candy Store -- Judge a Book by Its Cover -- Summary -- Chapter 19 Taking Control of Command Bars -- Taking Inventory with CommandBars -- Reflecting on a CommandBar -- The Bendy CommandBarControl Object -- Crafting Custom Command Bars -- Summary -- Chapter 20 User Form Construction -- User Form Development Features -- A Simple Form Walkthrough -- Forms Are Meant to Be Shown -- The Form Lifecycle -- User Friendly Settings -- Summary -- Chapter 21 One Smart Cookie: Smart Documents with Excel 2003 -- Smart Document Basics -- A Smart Document Walkthrough -- Smart Document Resources -- Summary -- Chapter 22 Application Deployment Strategies -- Choose the Form -- Managing Change -- Summary -- Index -- A -- B -- C -- D -- E -- F -- G -- H -- I -- J -- K -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W -- X -- Y -- Z.