XlCmdType enumeration (Excel)
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. |
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.