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


The information in this article applies to:

  • Microsoft Excel 2002
  • Microsoft Excel 2000
  • Microsoft PowerPoint 2002
  • Microsoft PowerPoint 2000
  • Microsoft Word 2002
  • Microsoft Word 2000
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0
  • Microsoft Visual Basic Professional Edition for Windows 6.0
This article was previously published under Q254006

SUMMARY

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:

AccData.exe

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

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.

MORE INFORMATION

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.

Modification Type:MinorLast Reviewed:8/11/2004
Keywords:kbAutomation kbfile kbinfo KB254006
©2004 Microsoft Corporation. All rights reserved.