Excel 2021 / Microsoft 365 Programming By Example

PART I: EXCEL VBA PRIMER
1: Excel Macros: A Quick Start in Excel VBA Programming
2: Excel Programming Environment: A Quick Overview of its Tools and Features (VBE)
3: Excel VBA Fundamentals: A Quick Reference to Writing VBA Code
4: Excel VBA Procedures: A Quick Guide to Writing Function Procedures
5: Adding Decisions to Excel VBA Programs: A Quick Introduction to Conditional Statements
6: Adding Repeating Actions to Excel VBA Programs: A Quick Introduction to Looping Statements
7: Storing Multiple Values in Excel VBA Programs:A Quick Introduction to Working with Arrays
8: Keeping Track of Multiple Values in Excel VBA Programs: A Quick Introduction to Creating and Using Collections
9: Excel Tools for Testing and Debugging: A Quick Introduction to Testing VBA Programs
PART II: MANIPULATING FILES AND FOLDERS WITH VBA
10: File and Folder Manipulation with VBA
11: File and Folder Manipulation with Windows Script Host (WSH)
12: Using Low-Level File Access
PART III: CONTROLLING OTHER APPLICATIONS WITH VBA
13 Using Excel VBA to Interact with Other Applications
14: Using Excel with Microsoft Access
PART IV: ENHANCING THE USER EXPERIENCE
15: Event-Driven Programming
16: Using Dialog Boxes
17: Creating Custom Forms
18: Formatting Worksheets with VBA
19: Context Menu Programming and Ribbon Customizations
20: Printing and Sending Email from Excel
PART V: EXCEL TOOLS FOR DATA ANALYSIS
21: Using and Programming Excel Tables
22: Programming PivotTables and PivotCharts
23: Getting and Transforming Data in Excel
PART VI: TAKING CHARGE OF PROGRAMMING ENVIRONMENT
24: Programming the Visual Basic Editor (VBE)
25: Calling Windows API Functions from VBA
PART VII: ADVANCED CONCEPTS IN EXCEL VBA
26: Creating Classes in VBA
PART VIII: WORKING TOGETHER: VBA, HTML, XML, AND THE REST API
27: HTML Programming and Web Queries
28: Using XML in Excel 2021
29: Excel and Rest API
Index