Business Programming with Excel VBA
Edition 1
|
(rev. 2)
- Introduction
- Chapter 1: Getting Started – Learning About Macros
- Chapter 2: Recording and Editing Macros for Complex Tasks
- Chapter 3: Understanding Objects and Collections
- Chapter 4: Writing Simple Macro Procedures
- Chapter 5: Working with Ranges and Cells
- Chapter 6: Understanding Data Types, Variables, and Constants
- Chapter 7: Operators and Expressions
- Chapter 8: Built-In Functions in VBA and Excel
- Chapter 9: Using VBA Functions to Manipulate and Compare Strings
- Chapter 10: Formatting Data Values
- Chapter 11: Creating and Using Your Own Functions in VBA
- Chapter 12: Creating Excel User-Defined Functions
- Chapter 13: Making Decisions in VBA: Flow Control
- Chapter 14: Repeating Actions in VBA: Loops
- Chapter 15: Debugging and Testing VBA Code
- Chapter 16: Working with Excel's Built-In Objects and Collections
- Chapter 17: Working with Chart Objects
- Chapter 18: Using Excel's Built-In File Dialogs
- Chapter 19: Working With Pivot Tables
- Chapter 20: Advanced Topics for Variables, Constants, and Data-Types
- Chapter 21: Defensive Programming: Preventing Errors Before They Happen
- Chapter 22: Error Handling
- Chapter 23: Creating Libraries and Whole Programs: Modular Programming Techniques
- Chapter 24: Creating and Using Arrays
- Chapter 25: Sorting and Searching Arrays
- Chapter 26: Creating Custom Dialogs with User Forms
- Chapter 27: Creating Custom Ribbons for Your Workbooks
- Chapter 28: Importing Data From A Database
- Chapter 29: Using VBA to Control Internet Explorer
- Chapter 30: Automating Solver With VBA
- Chapter 31: Using the FollowHyperlink Method
- Chapter 32: Using Event Procedures
- Chapter 33: Creating, Deploying, and Controlling Add-Ins
- Chapter 34: Creating Your Own Data Types
- Chapter 35: Creating Your Own Classes and Collections
- Chapter 36: Managing Files and Reading & Writing Text Files with VBA
- Chapter 37: Working With Other Applications
- Chapter 38: Using VBA to Send E-Mail with MS Outlook and Google Mail
- Chapter 39: Using VBA to Control MS Word
- Chapter 40: Using VBA with Google Docs
- Chapter 41: Using VBA to Control MS PowerPoint