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.