Creator Property [Excel 2003 VBA Language Reference]

Creator property as it applies to the Adjustments, CalloutFormat, ColorFormat, DiagramNode, DiagramNodeChildren, DiagramNodes, FillFormat, ListColumn, ListDataFormat, LineFormat, ListObject, ListObjects, ListRow, ListRows, PictureFormat, ShadowFormat, ShapeNode, ShapeNodes, TextEffectFormat, and ThreeDFormat objects.

Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only Long.

expression.Creator

expression Required. An expression that returns one of the above objects.

Creator property as it applies to all other objects in the Applies To list.

Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only xlCreatorCode.

expression.Creator

expression Required. An expression that returns all other objects in the Applies To list.

Remarks

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.

Example

This example displays a message about the creator of an Excel workbook.

Sub FindCreator()

    Dim myObject As Excel.Workbook
    Set myObject = ActiveWorkbook
    If myObject.Creator = &h5843454c Then
        MsgBox "This is a Microsoft Excel object."
    Else
        MsgBox "This is not a Microsoft Excel object."
    End If

End Sub

Applies to | AddIn Object | AddIns Collection Object | Adjustments Object | Application Object | Areas Collection | AutoCorrect Object | AutoFilter Object | AutoRecover Object | Axes Collection Object | Axis Object | AxisTitle Object | Border Object | Borders Collection | CalculatedFields Collection Object | CalculatedItems Collection Object | CalculatedMember Object | CalculatedMembers Collection | CalloutFormat Object | CellFormat Object | Characters Object | Chart Object | ChartArea Object | ChartColorFormat Object | ChartFillFormat Object | ChartGroup Object | ChartGroups Collection | ChartObject Object | ChartObjects Collection Object | Charts Collection | ChartTitle Object | ColorFormat Object | Comment Object | Comments Collection Object | ConnectorFormat Object | ControlFormat Object | Corners Object | CubeField Object | CubeFields Collection Object | CustomProperties Collection | CustomProperty Object | CustomView Object | CustomViews Collection Object | DataLabel Object | DataLabels Collection Object | DataTable Object | DefaultWebOptions Object | Diagram Object | DiagramNode Object | DiagramNodeChildren Collection | DiagramNodes Collection | Dialog Object | Dialogs Collection Object | DisplayUnitLabel Object | DownBars Object | DropLines Object | Error Object | ErrorBars Object | ErrorCheckingOptions Object | Errors Object | FillFormat Object | Filter Object | Filters Collection Object | Floor Object | Font Object | FormatCondition Object | FormatConditions Collection Object | FreeformBuilder Object | Graphic Object | Gridlines Object | GroupShapes Collection Object | HiLoLines Object | HPageBreak Object | HPageBreaks Collection Object | Hyperlink Object | Hyperlinks Collection | Interior Object | LeaderLines Object | Legend Object | LegendEntries Collection Object | LegendEntry Object | LegendKey Object | LineFormat Object | LinkFormat Object | ListColumn Object | ListColumns Collection | ListDataFormat Object | ListObject Object | ListObjects Collection | ListRow Object | ListRows Collection | Mailer Object | Name Object | Names Collection Object | ODBCError Object | ODBCErrors Collection Object | OLEDBError Object | OLEDBErrors Collection Object | OLEFormat Object | OLEObject Object | OLEObjects Collection Object | Outline Object | PageSetup Object | Pane Object | Panes Collection Object | Parameter Object | Parameters Collection Object | Phonetic Object | Phonetics Collection Object | PictureFormat Object | PivotCache Object | PivotCaches Collection Object | PivotCell Object | PivotField Object | PivotFields Collection Object | PivotFormula Object | PivotFormulas Collection Object | PivotItem Object | PivotItemList Collection | PivotItems Collection Object | PivotLayout Object | PivotTable Object | PivotTables Collection Object | PlotArea Object | Point Object | Points Collection Object | PublishObject Object | PublishObjects Collection Object | QueryTable Object | QueryTables Collection Object | Range Collection | RecentFile Object | RecentFiles Collection Object | RoutingSlip Object | Scenario Object | Scenarios Collection Object | Series Object | SeriesCollection Collection Object | SeriesLines Object | ShadowFormat Object | Shape Object | ShapeNode Object | ShapeNodes Collection Object | ShapeRange Collection | Shapes Collection | Sheets Collection Object | SmartTag Object | SmartTagAction Object | SmartTagActions Collection | SmartTagOptions Object | SmartTagRecognizer Object | SmartTagRecognizers Collection | SmartTags Collection | SoundNote Object | Style Object | Styles Collection | Tab Object | TextEffectFormat Object | TextFrame Object | ThreeDFormat Object | TickLabels Object | TreeviewControl Object | Trendline Object | Trendlines Collection Object | UpBars Object | UsedObjects Collection | Validation Object | VPageBreak Object | VPageBreaks Collection Object | Walls Object | Watch Object | Watches Collection | WebOptions Object | Window Object | Windows Collection Object | Workbook Object | Workbooks Collection | Worksheet Object | WorksheetFunction Object | Worksheets Collection | XmlDataBinding Object | XmlMap Object | XmlMaps Collection | XmlNamespace Object | XmlNamespaces Collection | XmlSchema Object | XmlSchemas Collection | XPath Object

See Also | Application Property