Gantt Chart Sample Add-In is available for download

This article was previously published under Q254008
This article has been archived. It is offered "as is" and will no longer be updated.
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:
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.
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:


Excel Workbook Template


Excel Workbook Sample:


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

GanttAdn COMAddins COMAdd-ins COM Addin Add-in Addins Add-ins Automation Automate

Article ID: 254008 - Last Review: 12/05/2015 18:37:31 - Revision: 5.4

Microsoft Excel 2000 Standard Edition, Microsoft Excel 2002 Standard Edition, Microsoft Office Excel 2003, Microsoft Visual Basic 6.0 Professional Edition, Microsoft Visual Basic Enterprise Edition for Windows 6.0

  • kbnosurvey kbarchive kbautomation kbfile kbinfo kbsample KB254008