Gantt Chart Sample Add-In is available for download

Article translations Article translations
Article ID: 254008 - View products that this article applies to.
This article was previously published under Q254008
Expand all | Collapse all

On This Page

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

Properties

Article ID: 254008 - Last Review: January 27, 2007 - Revision: 5.4
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 Enterprise Edition for Windows 6.0
Keywords: 
kbautomation kbfile kbinfo kbsample KB254008

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com