Controlling Applications Using Automation
What Is Automation?
Working with Other Applications
Example: Building an Excel Chart
Introducing WithEvents
Creating Automation Components
Creating and Using an ActiveX Code Component
Raising Events from ActiveX Components
Registering ActiveX Components
Handling Errors in ActiveX Components
In-Process vs. Out-of-Process Components
Understanding Instancing
Advanced Class Module Issues
Creating a Collection Class
Creating Default Members
Creating an Enumeration Function
Adding Enumerated Types
Building ActiveX Controls
What Is an ActiveX Control?
Creating the ProgressMeter Project
Adding the TestMeter Project
Drawing the ProgressMeter
Running the ProgressMeter at Design Time
Setting up the Control’s Resize Event Procedure
Working with the ProgressMeter’s Properties
Using the ActiveX Control Interface Wizard
Giving the ProgressMeter a Property Page
Adding Events to the ProgressMeter Control
Compiling the ProgressMeter Control
Distributing the ProgressMeter Control
ActiveX Controls and the Internet
Advanced ADO Topics
Reviewing OLE DB and ADO
Managing Connections
Working with Data
Creating Recordsets in Memory
Persisting Recordsets
Retrieving Multiple Result Sets