Edit

Share via

QueryTable.Creator property (Excel)

  • Article

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Syntax

expression.Creator

expression A variable that represents a QueryTable object.

Remarks

If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. 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.

Data from web queries or text queries is imported as a QueryTable object, while all other external data is imported as a ListObject object. Use the QueryTable property of the ListObject to access the Creator property.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.