QueryTable.Creator Property
| Excel Developer Reference |
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. You can use the QueryTable property of the ListObject to access the Creator property.
See Also