Additional References
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.
The following books and Web sites provide additional information about developing applications and solutions.
ActiveX Data Objects (ADO)
Microsoft Office Developer Center
(http://msdn.microsoft.com/en-us/office/default.aspx)
Vaughn, William R. Hitchhiker's Guide to Visual Basic and SQL Server, Sixth Edition. Redmond, WA: Microsoft Press, 1998**.**
Administrator Control over Passwords
Microsoft Office Resource Kit Web site
(http://www.microsoft.com/office/ork/)
Microsoft Office 2000 Resource Kit. Redmond, WA: Microsoft Press, 1999.
Administrator Control over Internet Explorer
Internet Explorer Administration Kit Web site
(http://ieak.microsoft.com/)
Answer Wizard SDK
Microsoft Office Resource Kit Web site
(http://www.microsoft.com/office/ork/)
Microsoft Office 2000 Resource Kit. Redmond, WA: Microsoft Press, 1999.
Calling the Windows API from VBA
Appleman, Dan. Dan Appleman's Visual Basic 5.0 Programmer's Guide to the Win32 API. Indianapolis, IN: Macmillan Computer Publishing, 1998.
Bockmann, Christopher J., Lars Klander, and Lingyan Tang. Visual Basic Programmer's Library. Las Vegas, NV: Jamsa Press, 1998.
Getz, Ken, and Mike Gilbert. Visual Basic Language Developer's Handbook. Alameda, CA: Sybex, 1999.
O'Brien, Timothy, Steven Pogge, and Geoffrey White. Microsoft Access 97 Developer's Handbook. Redmond, WA: Microsoft Press, 1997.
Creating Add-ins and DLLs in Microsoft® Visual Basic®
Microsoft Developer Network Web site
(http://msdn.microsoft.com/en-us/default.aspx)
Microsoft Visual Basic 6.0 Programmer's Guide. Redmond, WA: Microsoft Press, 1998.
Cornell, Gary, and Dave Jezak. Core Visual Basic 6. Upper Saddle River, NJ: Prentice Hall PTR, 1998.
McKinney, Bruce. Hardcore Visual Basic, Second Edition. Redmond, WA: Microsoft Press, 1997.
Creating and Using DHTML Scriptlets
Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/en-us/library/ms950396.aspx)
Creating Application-Specific Templates and Add-ins
Boctor, David. Microsoft Office 2000/Visual Basic Fundamentals. Redmond, WA: Microsoft Press, 1999.
Getz, Ken, Paul Litwin, and Mike Gilbert. Access 2000 Developer's Handbook, Volume 1: Desktop Edition. Alameda, CA: Sybex, 1999.
Creating COM Add-ins with Visual C++ and Visual J++
Microsoft Developer Network Web site
(http://msdn.microsoft.com/en-us/default.aspx)
Creating Object Models in VBA
Getz, Ken, and Mike Gilbert. Visual Basic Language Developer's Handbook. Alameda, CA: Sybex, 1999.
Stearns, Dave. "The Basics of Programming Model Design." MSDN Online Web site at http://msdn.microsoft.com/en-us/library/ms809977.aspx.
Creating PivotTable Reports
Microsoft Office Developer Center
(http://msdn.microsoft.com/en-us/office/default.aspx)
Wells, Eric, and Steve Harshberger. Microsoft Excel 97 Developer's Handbook. Redmond, WA: Microsoft Press, 1997.
Data Access Objects (DAO)
Microsoft Office Developer Center
(http://msdn.microsoft.com/en-us/office/default.aspx)
Microsoft Jet Database Engine Programmer's Guide, Second Edition. Redmond, WA: Microsoft Press, 1997
Database Design
Hernandez, Michael J. Database Design for Mere Mortals. Reading, MA: Addison-Wesley Developers Press, 1997.
Roman, Steven. Access Database Design and Programming. Sebastopol, CA: O'Reilly & Associates, 1997.
Debugging VBA Code
Maguire, Steve. Writing Solid Code. Redmond, WA: Microsoft Press, 1993.
McConnell, Steve. Code Complete. Redmond, WA: Microsoft Press, 1993.
Debugging and Error Handling in Script
Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/en-us/library/ms950396.aspx)
DHTML
Isaacs, Scott. Inside Dynamic HTML. Redmond, WA: Microsoft Press, 1997.
Simpson, Alan. Official Microsoft Internet Explorer 4 Site Builder Toolkit. Redmond, WA: Microsoft Press, 1998.
Disabling User Passwords
Microsoft Office 2000 Resource Kit. Redmond, WA: Microsoft Press, 1999.
General Security Issues
Microsoft Security Advisor Web site
(http://www.microsoft.com/security/)
HTML Help
Steve Wexler. Official Microsoft HTML Help Authoring Kit. Redmond, WA: Microsoft Press, 1998.
Internet Information Server Authentication and Encryption Configuration
Microsoft Internet Information Server 4.0 Online documentation
http://www.microsoft.com/technet/archive/winntas/default.mspx?mfr=true)
Macro Viruses
International Computer Security Association (ICSA) Web site
http://www.icsa.net)
Microsoft Jet Replication
Microsoft Jet Database Engine Programmer's Guide, Second Edition. Redmond, WA: Microsoft Press, 1997.
Dove, Debra. "Database Replication in Microsoft Jet."**(RepJet.doc)
Microsoft Outlook
Byrne, Randy. Building Applications with Microsoft Outlook 2000. Redmond, WA: Microsoft Press, 1999.
Microsoft SQL Server
Microsoft SQL Server Web site
(http://www.microsoft.com/sql)
Naming Conventions
Microsoft Knowledge Base article: "Built-in Constants in Visual Basic for Applications," Q112671 (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.
Signcode.exe Utility for Signing COM Add-ins
SQL Server Replication
SQL Server Books Online, Replication.
Subclassing Windows Messages
Bockmann, Christopher J., Lars Klander, and Lingyan Tang. Visual Basic Programmer's Library. Las Vegas, NV: Jamsa Press, 1998.
Training Resources for Office XP
http://office.microsoft.com/en-us/training/FX100565001033.aspx
Useful Tips and Sample Code
Microsoft Office Developer Center
(http://msdn.microsoft.com/en-us/office/default.aspx)
The Microsoft Knowledge Base
http://support.microsoft.com/support
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.
Using ActiveX Data Objects with SQL Server
Vaughn, William R. Hitchhiker's Guide to Visual Basic and SQL Server, Sixth Edition. Redmond, WA: Microsoft Press, 1998**.**
SQL Server Books Online, Building SQL Server Applications.
Using Scriptlets
Scriptlet Technology Web site
(http://www.microsoft.com/technet/archive/itsolutions/intranet/build/chapt9.mspx?mfr=true)
Isaacs, Scott. Inside Dynamic HTML. Redmond, WA: Microsoft Press, 1997.
Scriptlet Wizard on Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/en-us/library/ms950396.aspx)
Using Scriptlets in HTML Files
Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/en-us/library/ms950396.aspx)
Isaacs, Scott. Inside Dynamic HTML. Redmond, WA: Microsoft Press, 1997.
Windows File System Security
Microsoft Windows 95 Resource Kit. Redmond, WA: Microsoft Press, 1995.
Microsoft Windows 98 Resource Kit. Redmond, WA: Microsoft Press, 1998.
Microsoft Windows NT Workstation Resource Kit. Redmond, WA: Microsoft Press, 1996.
Microsoft Windows NT Server Resource Kit. Redmond, WA: Microsoft Press, 1996.
WinHelp 4.0
Microsoft Help Workshop (download from the Microsoft Technical Support Web site at http://www.microsoft.com/downloads/details.aspx?familyid=34d35502-4de9-4676-952c-34cc7f64f098&displaylang=en)
Microsoft Windows 95 Help Authoring Kit. Redmond, WA: Microsoft Press, 1995.
Working with JScript
Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/en-us/library/ms950396.aspx)
Working with VBA
Getz, Ken, and Mike Gilbert. Visual Basic Language Developer's Handbook. Alameda, CA: Sybex, 1999.
Working with VBScript
Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/en-us/library/ms950396.aspx)
Working with the Visual Basic for Applications Extensibility Library
Getz, Ken, and Mike Gilbert. Visual Basic Language Developer's Handbook. Alameda, CA: Sybex, 1999.
Wrapping API Functions
Microsoft Developer Network Web site
(http://msdn.microsoft.com/en-us/default.aspx)
Appleman, Dan. Dan Appleman's Visual Basic 5.0 Programmer's Guide to the Win32 API. Indianapolis, IN: Macmillan Computer Publishing, 1998.
Writing Reusable Code
McConnell, Steve. Code Complete. Redmond, WA: Microsoft Press, 1993.
XML
XML Developer Center
(http://msdn.microsoft.com/en-us/xml/default.aspx)