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


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

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.

↑ 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