Additional References

  • Article

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)