CD-ROM 4
14.0 Exploring the Object Models of the Office Products
Figuring Out Object Models
Working with the Object Browser: Access
Knowing the Interactive Product: Word
Mining the Help File: Excel
15.0 Working with Active Objects
Active Properties in Office
Excel’s Active and Selection Properties
Word’s Active and Selection Properties
The Access Screen Object
16.0 Using Another Product's Features with Automation
Expanding Your Horizons Using Automation
Getting to the Object Model
Working with Data Using Automation
17.0 Advanced User Form
Techniques
Restricting User Entry
Using List Boxes and Combo Boxes
Creating a Tabbed Dialog Box
Additional ActiveX Controls
|
CD-ROM 5
18.0 Techniques with VBA Variables
Scope, Lifetime, and Precedence
Passing by Value and by Reference
Optional Arguments
Creating Your Own Collections
19.0 Adding Data to Excel,
Access, and Outlook
Using VBA to Work with Data
Adding Values to an Excel Worksheet
Adding ADO Data to Excel
Adding a Database Record with ADO
Adding an Item to Outlook
20.0 Charting Your Data
Excel’s Chart Object
Creating a Chart
Creating an Excel Chart from Access
21.0 Adding Content to
Word and PowerPoint
Adding Text to a Word Document
Adding Content to PowerPoint
22.0 Giving Your Solutions to Others
Sharing the Wealth
Using Custom Toolbars
Office Templates and Add-Ins
Securing Your Code
Using Microsoft Office 2000 Developer to Deploy Solutions
|
|
