ÿþ<html xmlns:mso="urn:schemas-microsoft-com:office:office" xmlns:msdt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><script> function getHelp(link) { window.open("http://" + location.hostname + "/Explorer/" + link, "_help", "left=400,resizable=yes,toolbar=yes,width=200,height=200,scrollbars=yes").focus(); } function showReturns(returns) { window.status = returns; } </script><head> <!--[if gte mso 9]><xml> <mso:CustomDocumentProperties> <mso:Order msdt:dt="string">347700.000000000</mso:Order> </mso:CustomDocumentProperties> </xml><![endif]--> <title>Chapter 22</title> <!--mstheme--><link rel="stylesheet" type="text/css" id="onetidThemeCSS" href="../_themes/simple/simp1011-1200.css"><meta name="Microsoft Theme" content="simple 1011, default"> </head><body> <H1>Excel Add-In Objects</H1> <h2>AddIn (1995) <img src="MSGBOX02.ICO" alt="Represents a single add-in, either installed or not installed. The AddIn object is a member of the AddIns collection. The AddIns collection contains a list of all the add-ins available to Microsoft Excel, regardless of whether theyre installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu)." width="16" height="16" onclick="getHelp('xlobjAddIn.htm');showMozHelp('Represents a single add-in, either installed or not installed. The AddIn object is a member of the AddIns collection. The AddIns collection contains a list of all the add-ins available to Microsoft Excel, regardless of whether theyre installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu).');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Author<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the author of the comment. Read-only String." width="16" height="16" onclick="getHelp('xlproAuthor.htm')" onmouseover="showReturns('Returns: String')"><br>CLSID<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns a read-only unique identifier, or CLSID identifying an object, as a String." width="16" height="16" onclick="getHelp('xlproCLSID.htm')" onmouseover="showReturns('Returns: String')"><br>Comments<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns a Comments collection that represents all the comments for the specified worksheet. Read-only." width="16" height="16" onclick="getHelp('xlproComments.htm')" onmouseover="showReturns('Returns: String')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>FullName<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the name of the object, including its path on disk, as a string. Read-only String." width="16" height="16" onclick="getHelp('xlproFullName.htm')" onmouseover="showReturns('Returns: String')"><br>Installed [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the add-in is installed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproInstalled.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Keywords<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Path<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Path property as it applies to the AutoRecover object." width="16" height="16" onclick="getHelp('xlproPath.htm')" onmouseover="showReturns('Returns: String')"><br>progID<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>Subject<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the subject for the mailer or routing slip. Read/write String." width="16" height="16" onclick="getHelp('xlproSubject.htm')" onmouseover="showReturns('Returns: String')"><br>Title<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the title of the Web page when the document is saved as a Web page. Read/write String." width="16" height="16" onclick="getHelp('xlproTitle.htm')" onmouseover="showReturns('Returns: String')"><br><h2>AddIns (1995) <img src="MSGBOX02.ICO" alt="A collection of AddIn objects that represents all the add-ins available to Microsoft Excel, regardless of whether theyre installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu)." width="16" height="16" onclick="getHelp('xlobjAddIns.htm');showMozHelp('A collection of AddIn objects that represents all the add-ins available to Microsoft Excel, regardless of whether theyre installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu).');"></h2>Add(Filename, [CopyFile]) <input type="image" src="MSGBOX02.ICO" alt="Returns: AddIn. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: AddIn')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: AddIn. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: AddIn')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br></body> </html>