Microsoft KB Archive/214014

= XL2000: How to Set the Descriptive Name of an Add-in File =

Article ID: 214014

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214014





SUMMARY
In Microsoft Excel 2000, it is possible to create a descriptive name and descriptive text for an add-in file that is listed in the Add-Ins dialog box.



MORE INFORMATION
In Excel, the Add-Ins dialog box lists add-in files that are automatically opened when you start Excel. In the Add-Ins dialog box, these files have descriptive names that resemble the following examples:

Analysis ToolPak

Analysis ToolPak - VBA

MS Query Add-in

Report Manager

Add-in files also have descriptive text that appears in the lower part of the dialog box. For example, the descriptive text for the Open Database Connectivity (ODBC) add-in states the following:

"Functions for accessing SQL-based data sources via ODBC"

To set the descriptive name and descriptive text for a workbook that is to be made into an add-in file, follow these steps:  With the workbook active, click Properties on the File menu. Click the Summary tab, and then type the following values:

Title:

Comments:

 Click OK to accept the changes.

When you make the workbook into an add-in, the new add-in uses the descriptive name and text that you typed when you added the add-in to the Add-Ins dialog box.

NOTE: If you have already created your add-in file, but you did not properly set the descriptive name and text, it may not be possible to modify the existing add-in file. Instead, you must reopen your source workbook, set the descriptive name and text, and then re-create the add-in.

For additional information about creating an add-in, click the article number below to view the article in the Microsoft Knowledge Base:

211563 XL2000: How to Create an Add-in File

Additional query words: x XL2000

Keywords: kbhowto KB214014

-

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

© Microsoft Corporation. All rights reserved.