XlCmdType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the value of the CommandText property.
public enum class XlCmdTypepublic enum XlCmdTypePublic Enum XlCmdType- Inheritance
-
XlCmdType
Fields
| Name | Value | Description |
|---|---|---|
| xlCmdCube | 1 | Contains a cube name for an OLAP data source. |
| xlCmdSql | 2 | Contains an SQL statement. |
| xlCmdTable | 3 | Contains a table name for accessing OLE DB data sources. |
| xlCmdDefault | 4 | Contains command text that the OLE DB provider understands. |
| xlCmdList | 5 | Contains a pointer to list data. |
| xlCmdTableCollection | 6 | Contains the name of a table collection. |
| xlCmdExcel | 7 | Contains an Excel formula. |
| xlCmdDAX | 8 | Contains a Data Analysis Expressions (DAX) formula. |