Microsoft KB Archive/254008

= Gantt Chart Sample Add-In is available for download =

Article ID: 254008

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Office Excel 2003
 * Microsoft Visual Basic 6.0 Professional Edition
 * Microsoft Visual Basic 6.0 Enterprise Edition

-



This article was previously published under Q254008



SUMMARY
The Gantt Chart Sample Add-in is a sample COM add-in designed for use with Microsoft Excel. The purpose of this sample is to illustrate how to create a COM add-in using the Add-in Designer with Microsoft Visual Basic 6.0.

The following file is available for download from the Microsoft Download Center:

GanttAdn.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
This sample add-in provides the following features:
 * Adds and removes custom CommandBar controls at run time.
 * Implements What's This Help for Office CommandBars.
 * Displays a modal dialog box that is owned by Excel.
 * Demonstrates techniques for using a COM add-in with an Excel workbook template.
 * Demonstrates Automation with Excel to manipulate worksheet data and charts at run time.

Files Included with the Sample
The download contains a Readme as well as the following files.

Visual Basic Project Files for the Add-in:

Addin.DCA

Addin.Dsr

frmColors.frm

frmFormat.frm

frmFormat.frx

GanttCht.dll

GanttCht.exp

GanttCht.lib

GanttCht.vbp

Excel Workbook Template

GanttCht.xlt

Excel Workbook Sample:

Sample.xls

Help File and Help File Project Used for What's This Help:

..\Help\GanttAdn.hlp

..\Help\GanttAdn.hpj

..\Help\GanttAdn.rtf

Additional query words: GanttAdn COMAddins COMAdd-ins COM Addin Add-in Addins Add-ins Automation Automate

Keywords: kbautomation kbfile kbinfo kbsample KB254008

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.