INFO: Access Data Retrieval Sample Add-In Available for Download

The Access Data Retrieval Sample Add-in is a sample COM add-in designed for use with Microsoft Excel, Microsoft Word, and Microsoft PowerPoint.

The following file is available for download from the Microsoft Download Center:
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

The purpose of this sample is to illustrate how to create a COM add-in that provides the following features:

• Can be used with more than one Microsoft Office application.
• Adds and removes custom CommandBar controls at run time.
• Implements What's This Help for Office CommandBars.
• Determines the application hosting the add-in so that it can take actions that are specific to the host application.
• Displays modal dialog boxes that are owned by the host application.
• Provides public methods that can be called from a Microsoft Visual Basic for Applications (VBA) macro in one of the host applications.

Files Included with the Sample

The download contains a Readme as well as the following files.

Visual Basic Project files for the add-in:

AccData.vbp
AddIn.cls
clsData.cls
frmGetChart.frm
frmGetChart.frx
frmGetData.frm
frmGetData.frx
Globals.bas
pic.bmp
AccData.dll
AccData.exp
AccData.lib

Visual Basic Project files for the application that registers the add-in:

..\Register\Register.vbp
..\Register\frmRegister.frm
..\Register\Register.exe

Help file and Help file project used for What's This Help

..\WinHelp\AccData.h
..\WinHelp\AccData.hlp
..\WinHelp\AccData.hpj
..\WinHelp\AccData.rtf

(c) Microsoft Corporation 2000, All Rights Reserved. Contributions by Lori Turner, Microsoft Corporation.