ÿþ<html><script> function getHelp(link) { window.open("http://usingsharepoint.com/ProgExcel/Help/" + link, "_help", "left=400").focus(); } function showReturns(returns) { window.status = returns; } </script> <!--mstheme--><link rel="stylesheet" type="text/css" id="onetidThemeCSS" href="../_themes/simple/simp1011-1200.css"><meta name="Microsoft Theme" content="simple 1011, default"> <body> <H1>Excel XML Objects</H1> <h2>CustomProperties (2002) <img src="MSGBOX02.ICO" alt="A collection of CustomProperty objects that represent additional information. The information can be used as metadata for XML." width="16" height="16" onclick="getHelp('xlobjCustomProperties.htm');showMozHelp('A collection of CustomProperty objects that represent additional information. The information can be used as metadata for XML.');"></h2>Add(Name, Value) <input type="image" src="MSGBOX02.ICO" alt="Returns: CustomProperty. 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: CustomProperty')"><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: CustomProperty. 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: CustomProperty')"><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><h2>CustomProperty (2002) <img src="MSGBOX02.ICO" alt="Represents identifier information. Identifier information can be used as metadata for XML." width="16" height="16" onclick="getHelp('xlobjCustomProperty.htm');showMozHelp('Represents identifier information. Identifier information can be used as metadata for XML.');"></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>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>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Name [= setting]<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>Value [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. For the Application object, always returns &amp;quot;Microsoft Excel&amp;quot;. For the CubeField object, the name of the specified field. For the Style object, the name of the specified style. Read-only String." width="16" height="16" onclick="getHelp('xlproValue.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>ListColumn (2003) <img src="MSGBOX02.ICO" alt="Represents a column in a ListObject object). " width="16" height="16" onclick="getHelp('xlobjListColumn.htm');showMozHelp('Represents a column in a ListObject object). ');"></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>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>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Index<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. For information about using the Index worksheet function in Visual Basic, see Using Worksheet Functions in Visual Basic." width="16" height="16" onclick="getHelp('xlproIndex.htm')" onmouseover="showReturns('Returns: Int32')"><br>ListDataFormat<input type="image" src="MSGBOX02.ICO" alt="Returns: ListDataFormat. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ListDataFormat')"><br>Name [= setting]<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>Range<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Although you can use the Shapes.Range(1)." width="16" height="16" onclick="getHelp('xlproRange.htm')" onmouseover="showReturns('Returns: Range')"><br>SharePointFormula<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>TotalsCalculation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlTotalsCalculation. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XlTotalsCalculation')"><br>XPath<input type="image" src="MSGBOX02.ICO" alt="Returns: XPath. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XPath')"><br><h2>ListColumns (2003) <img src="MSGBOX02.ICO" alt="A collection of all the ListColumn objects in the specified ListColumn object represents a column in the list." width="16" height="16" onclick="getHelp('xlobjListColumns.htm');showMozHelp('A collection of all the ListColumn objects in the specified ListColumn object represents a column in the list.');"></h2>Add([Position]) <input type="image" src="MSGBOX02.ICO" alt="Returns: ListColumn. 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: ListColumn')"><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: ListColumn. 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: ListColumn')"><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><h2>ListDataFormat (2003) <img src="MSGBOX02.ICO" alt="The ListColumn object. These properties are read-only." width="16" height="16" onclick="getHelp('xlobjListDataFormat.htm');showMozHelp('The ListColumn object. These properties are read-only.');"></h2>AllowFillIn<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><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>Choices<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><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>DecimalPlaces<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Int32')"><br>DefaultValue<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>IsPercent<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>lcid<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Int32')"><br>MaxCharacters<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Int32')"><br>MaxNumber<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>MinNumber<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><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>ReadOnly<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the workbook has been opened as read-only. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproReadOnly.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Required<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: XlListDataType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: XlListDataType')"><br><h2>ListObject (2003) <img src="MSGBOX02.ICO" alt="Represents a list object on a worksheet. The ListObjects collection contains all the list objects on a worksheet. " width="16" height="16" onclick="getHelp('xlobjListObject.htm');showMozHelp('Represents a list object on a worksheet. The ListObjects collection contains all the list objects on a worksheet. ');"></h2>Active<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><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>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>DataBodyRange<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the range that contains the data area in the PivotTable report. Read-only." width="16" height="16" onclick="getHelp('xlproDataBodyRange.htm')" onmouseover="showReturns('Returns: Range')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>DisplayRightToLeft<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the specified window or worksheet is displayed from right to left instead of from left to right. False if the object is displayed from left to right. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayRightToLeft.htm')" onmouseover="showReturns('Returns: Boolean')"><br>HeaderRowRange<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Range')"><br>InsertRowRange<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Range')"><br>ListColumns<input type="image" src="MSGBOX02.ICO" alt="Returns: ListColumns. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ListColumns')"><br>ListRows<input type="image" src="MSGBOX02.ICO" alt="Returns: ListRows. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ListRows')"><br>Name [= setting]<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>Publish(Target, LinkSource) <input type="image" src="MSGBOX02.ICO" alt="Returns: String. Saves an item or a collection of items in a document to a Web page." width="16" height="16" onclick="getHelp('xlmthPublish.htm')" onmouseover="showReturns('Returns: String')"><br>QueryTable<input type="image" src="MSGBOX02.ICO" alt="Returns: QueryTable. Returns a QueryTable object that represents the query table that intersects the specified range. Read-only." width="16" height="16" onclick="getHelp('xlproQueryTable.htm')" onmouseover="showReturns('Returns: QueryTable')"><br>Range<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Although you can use the Shapes.Range(1)." width="16" height="16" onclick="getHelp('xlproRange.htm')" onmouseover="showReturns('Returns: Range')"><br>Refresh() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Updates the query table. Boolean." width="16" height="16" onclick="getHelp('xlmthRefresh.htm')" onmouseover="showReturns('Returns: Void')"><br>Resize(Range) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SharePointURL<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>ShowAutoFilter [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowTotals [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>SourceType<input type="image" src="MSGBOX02.ICO" alt="Returns: XlListObjectSourceType. This example determines the unique name of the first chart (in the first workbook) saved as a Web page, and then it sets the Boolean variable blnChartFound to True. If no items in the document have been saved as Chart components, blnChartFound is False." width="16" height="16" onclick="getHelp('xlproSourceType.htm')" onmouseover="showReturns('Returns: XlListObjectSourceType')"><br>TotalsRowRange<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Range')"><br>Unlink() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>Unlist() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>UpdateChanges([iConflictType]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>XmlMap<input type="image" src="MSGBOX02.ICO" alt="Returns: XmlMap. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XmlMap')"><br><h2>ListObjects (2003) <img src="MSGBOX02.ICO" alt="A collection of all the ListObject objects on a worksheet. Each ListObject object represents a list in the worksheet." width="16" height="16" onclick="getHelp('xlobjListObjects.htm');showMozHelp('A collection of all the ListObject objects on a worksheet. Each ListObject object represents a list in the worksheet.');"></h2>Add([SourceType], [Source], [LinkSource], [XlListObjectHasHeaders], [Destination]) <input type="image" src="MSGBOX02.ICO" alt="Returns: ListObject. 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: ListObject')"><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: ListObject. 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: ListObject')"><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><h2>ListRow (2003) <img src="MSGBOX02.ICO" alt="Represents a row in a List object. The ListRow object is a member of the ListRows collection contains all the rows in a list object. " width="16" height="16" onclick="getHelp('xlobjListRow.htm');showMozHelp('Represents a row in a List object. The ListRow object is a member of the ListRows collection contains all the rows in a list object. ');"></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>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>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Index<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. For information about using the Index worksheet function in Visual Basic, see Using Worksheet Functions in Visual Basic." width="16" height="16" onclick="getHelp('xlproIndex.htm')" onmouseover="showReturns('Returns: Int32')"><br>InvalidData<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><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>Range<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Although you can use the Shapes.Range(1)." width="16" height="16" onclick="getHelp('xlproRange.htm')" onmouseover="showReturns('Returns: Range')"><br><h2>ListRows (2003) <img src="MSGBOX02.ICO" alt="A collection of all the ListRow objects in the specified ListRow object represents a row in the list." width="16" height="16" onclick="getHelp('xlobjListRows.htm');showMozHelp('A collection of all the ListRow objects in the specified ListRow object represents a row in the list.');"></h2>Add([Position]) <input type="image" src="MSGBOX02.ICO" alt="Returns: ListRow. 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: ListRow')"><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: ListRow. 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: ListRow')"><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><h2>XmlDataBinding (2003) <img src="MSGBOX02.ICO" alt="Represents the connection to the source data for an XmlMap object." width="16" height="16" onclick="getHelp('xlobjXmlDataBinding.htm');showMozHelp('Represents the connection to the source data for an XmlMap object.');"></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>ClearSettings() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><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>LoadSettings(Url) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><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>Refresh() <input type="image" src="MSGBOX02.ICO" alt="Returns: XlXmlImportResult. Updates the query table. Boolean." width="16" height="16" onclick="getHelp('xlmthRefresh.htm')" onmouseover="showReturns('Returns: XlXmlImportResult')"><br>SourceUrl<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><h2>XmlMap (2003) <img src="MSGBOX02.ICO" alt="Represents an XML map that has been added to a workbook. " width="16" height="16" onclick="getHelp('xlobjXmlMap.htm');showMozHelp('Represents an XML map that has been added to a workbook. ');"></h2>AdjustColumnWidth [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the column widths are automatically adjusted for the best fit each time you refresh a query table. False if the column widths arent automatically adjusted with each refresh. The default value is True. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAdjustColumnWidth.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AppendOnImport [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><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>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>DataBinding<input type="image" src="MSGBOX02.ICO" alt="Returns: XmlDataBinding. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XmlDataBinding')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Export(Url, [Overwrite]) <input type="image" src="MSGBOX02.ICO" alt="Returns: XlXmlExportResult. Exports the chart in a graphic format." width="16" height="16" onclick="getHelp('xlmthExport.htm')" onmouseover="showReturns('Returns: XlXmlExportResult')"><br>ExportXml(Data) <input type="image" src="MSGBOX02.ICO" alt="Returns: XlXmlExportResult. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XlXmlExportResult')"><br>Import(Url, [Overwrite]) <input type="image" src="MSGBOX02.ICO" alt="Returns: XlXmlImportResult. This method should not be used. Sound notes have been removed from Microsoft Excel." width="16" height="16" onclick="getHelp('xlmthImport.htm')" onmouseover="showReturns('Returns: XlXmlImportResult')"><br>ImportXml(XmlData, [Overwrite]) <input type="image" src="MSGBOX02.ICO" alt="Returns: XlXmlImportResult. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XlXmlImportResult')"><br>IsExportable<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Name [= setting]<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>PreserveColumnFilter [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>PreserveNumberFormatting [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>RootElementName<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>RootElementNamespace<input type="image" src="MSGBOX02.ICO" alt="Returns: XmlNamespace. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XmlNamespace')"><br>SaveDataSourceDefinition [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Schemas<input type="image" src="MSGBOX02.ICO" alt="Returns: XmlSchemas. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XmlSchemas')"><br>ShowImportExportValidationErrors [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br><h2>XmlMaps (2003) <img src="MSGBOX02.ICO" alt="Represents the collection of XmlMap objects that have been added to a workbook." width="16" height="16" onclick="getHelp('xlobjXmlMaps.htm');showMozHelp('Represents the collection of XmlMap objects that have been added to a workbook.');"></h2>Add(Schema, [RootElementName]) <input type="image" src="MSGBOX02.ICO" alt="Returns: XmlMap. 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: XmlMap')"><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: XmlMap. 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: XmlMap')"><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><h2>XmlNamespace (2003) <img src="MSGBOX02.ICO" alt="Represents a namespace that has been added to a workbook." width="16" height="16" onclick="getHelp('xlobjXmlNamespace.htm');showMozHelp('Represents a namespace that has been added to a workbook.');"></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>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>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>Prefix<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>Uri<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><h2>XmlNamespaces (2003) <img src="MSGBOX02.ICO" alt="Represents the collection of XmlNamespace objects in a workbook. " width="16" height="16" onclick="getHelp('xlobjXmlNamespaces.htm');showMozHelp('Represents the collection of XmlNamespace objects in a workbook. ');"></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>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>InstallManifest(Path, [InstallForAllUsers]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: XmlNamespace. 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: XmlNamespace')"><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>Value<input type="image" src="MSGBOX02.ICO" alt="Returns: String. For the Application object, always returns &amp;quot;Microsoft Excel&amp;quot;. For the CubeField object, the name of the specified field. For the Style object, the name of the specified style. Read-only String." width="16" height="16" onclick="getHelp('xlproValue.htm')" onmouseover="showReturns('Returns: String')"><br><h2>XmlSchema (2003) <img src="MSGBOX02.ICO" alt="Represents an XML schema contained by an XmlMap object." width="16" height="16" onclick="getHelp('xlobjXmlSchema.htm');showMozHelp('Represents an XML schema contained by an XmlMap object.');"></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>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>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>Namespace<input type="image" src="MSGBOX02.ICO" alt="Returns: XmlNamespace. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XmlNamespace')"><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>XML<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns a String representing a sample of the XML that would be passed to the action handler. Read-only." width="16" height="16" onclick="getHelp('xlproXML.htm')" onmouseover="showReturns('Returns: String')"><br><h2>XmlSchemas (2003) <img src="MSGBOX02.ICO" alt="Represents the collection of XmlMap object." width="16" height="16" onclick="getHelp('xlobjXmlSchemas.htm');showMozHelp('Represents the collection of XmlMap object.');"></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>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: XmlSchema. 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: XmlSchema')"><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><h2>XPath (2003) <img src="MSGBOX02.ICO" alt="Represents an XPath that has been mapped to a ListColumn object." width="16" height="16" onclick="getHelp('xlobjXPath.htm');showMozHelp('Represents an XPath that has been mapped to a ListColumn object.');"></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>Clear() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example clears the formulas and formatting in cells A1:G37 on Sheet1." width="16" height="16" onclick="getHelp('xlmthClear.htm')" onmouseover="showReturns('Returns: Void')"><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>Map<input type="image" src="MSGBOX02.ICO" alt="Returns: XmlMap. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XmlMap')"><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>Repeating<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>SetValue(Map, XPath, [SelectionNamespace], [Repeating]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>Value<input type="image" src="MSGBOX02.ICO" alt="Returns: String. For the Application object, always returns &amp;quot;Microsoft Excel&amp;quot;. For the CubeField object, the name of the specified field. For the Style object, the name of the specified style. Read-only String." width="16" height="16" onclick="getHelp('xlproValue.htm')" onmouseover="showReturns('Returns: String')"><br></body> </html>