Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

View products that this article applies to.

This article was previously published under Q254006

↑ Back to the top


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:
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.

↑ Back to the top

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:


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


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


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

↑ Back to the top

Keywords: KB254006, kbinfo, kbfile, kbautomation

↑ Back to the top

Article Info
Article ID : 254006
Revision : 10
Created on : 1/27/2007
Published on : 1/27/2007
Exists online : False
Views : 429