Where to Go from Here

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

For additional information about the subjects discussed in this chapter, see the following resources. If a file name is listed, that file is located in the ODETools\V9\Samples\OPG\Appendixes folder on the Office 2000 Developer CD-ROM, unless otherwise noted.

Working with VBA

Getz, Ken, and Mike Gilbert. Visual Basic Language Developer's Handbook. Alameda, CA: Sybex, 1999.

Useful VBA Sample Code

For samples and how-to articles that may provide interesting code, search the Visual Basic for Applications section of the Microsoft Knowledge Base for "VBA." The Knowledge Base is available at http://support.microsoft.com/support.

Optimizing VBA Code

Balena, Francesco. "88 Optimization Tips." Visual Basic Programmer's Journal 7, no. 14 (December 1997): 28-41.

Working with Class Modules

Chapter 9, "Custom Classes and Objects"

Working with VBScript

Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/scripting/default.htm)

Calling the Windows API

Chapter 10, "The Windows API and Other Dynamic-Link Libraries"

Creating and Using Add-ins

Chapter 11, "Add-ins, Templates, Wizards, and Libraries"

Preparing Your Code for the Year 2000

Microsoft Year 2000 Resource Center Web site
(http://www.microsoft.com/technet/topics/year2k/default.htm)

Code Samples

The code samples shown in this chapter, along with additional examples demonstrating similar techniques, can be copied from the files in the ODETools\V9\Samples\OPG\Samples\CH07 subfolder on the Office 2000 Developer CD-ROM.