Part One: Introduction to Excel 2007 VBA Programming Chapter 1: Automating Spreadsheet Tasks with Macros Chapter 2: Exploring the Visual Basic Editor (VBE) Chapter 3: Excel VBA Fundamentals Chapter 4: Using Variables, Data Types, and Constants Chapter 5: VBA Procedures: Subroutines and Functions Part Two: Controlling Program Execution Chapter 6: Decision Making with VBA Chapter 7: Repeating Actions in VBA Part Three: Keeping Track of Multiples Values Chapter 8: Working with Arrays Chapter 9: Working with Collections and Class Modules Part Four: Error Handling and Debugging Chapter 10: VBE Tools for Testing and Debugging Chapter 11: Conditional Compilation and Error Trapping Part Five: Manipulating Files and Folders with VBA Chapter 12: File and Folder Manipulation with VBA Chapter 13: File and Folder Manipulation with Windows Script Host (WSH) Chapter 14: Using Low-Level File Access Part Six: Controlling Other Applications with VBA Chapter 15: Using Excel VBA to Interact with Other Applications Chapter 16: Using Excel with Microsoft Access Part Seven: Enhancing the User Experience Chapter 17: Event-Driven Programming Chapter 18: Using Dialog boxes Chapter 19: Creating Custom Forms Chapter 20: Formatting Worksheets with VBA Chapter 21: Shortcut Menu Programming and Ribbon Customizatinos Part Eight: Programming Excel Special Features Chapter 22: Printing and Sending E-mail from Excel Chapter 23: Programming PivotTables and PivotCharts Chapter 24: Using and Programming Excel Tables Chapter 25: Programming Special Features Chapter 26: Programming the Visual Basic Editor 9VBE) Part Nine: Excel and Web Technologies Chapter 27: HTML Programming and Web Queries Chapter 28: Excel and Active Server pages Chapter 29: Using XML in Excel 2007 Chapter 30: Using and Programming Smart Tags Index.