Table of contents
Frontmatter
Contents
Acknowledgments
Introduction
Chapter 1: Automating Worksheet 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
Chapter 6: Decision Making with VBA
Chapter 7: Repeating Actions in VBA
Chapter 8: Working with Arrays
Chapter 9: Working with Collections and Class Modules
Chapter 10: VBE Tools for Testing and Debugging
Chapter 11: Conditional Compilation and Error Trapping
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
Chapter 15: Using Excel VBA to Interact with Other Applications
Chapter 16: Using Excel with Microsoft Access
Chapter 17: Event-Driven Programming
Chapter 18: Using Dialog Boxes
Chapter 19: Creating Custom Forms
Chapter 20: Formatting Worksheets with VBA
Chapter 21: Context Menu Programming and Ribbon Customizations
Chapter 22: Printing and Sending Email 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 (VBE)
Chapter 27: HTML Programming and Web Queries
Chapter 28: Excel and Active Server Pages
Chapter 29: Using XML in Excel 2013
Chapter 30: Calling Windows API Functions from VBA
Index
35 chapters available
