| title | api_name | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|
XlCmdType enumeration (Excel) |
|
4339b577-c29c-3c78-8433-df56c35b6633 |
06/08/2017 |
medium |
Specifies the value of the CommandText property.
| Name | Value | Description |
|---|---|---|
| xlCmdCube | 1 | Contains a cube name for an OLAP data source. |
| xlCmdDAX | 8 | Contains a Data Analysis Expressions (DAX) formula. |
| xlCmdDefault | 4 | Contains command text that the OLE DB provider understands. |
| xlCmdExcel | 7 | Contains an Excel formula. |
| xlCmdList | 5 | Contains a pointer to list data. |
| xlCmdSql | 2 | Contains an SQL statement. |
| xlCmdTable | 3 | Contains a table name for accessing OLE DB data sources. |
| xlCmdTableCollection | 6 | Contains the name of a table collection. |
[!includeSupport and feedback]