Programming Excel with VBA and .NET

Name

pivotcache.CommandType [= xlCmdType]

Synopsis

For pivot caches based on database queries, sets or returns the type of command used in CommandText as described in the following table.

Setting	CommandText is
xlCmdCube	The name of the OLAP cube
xlCmdDefault	A query string defined by the OLE DB provider
xlCmdSql	A SQL SELECT command
xlCmdTable	A table name from the data source

You can set CommandType only if QueryType is xlOLEDBQuery.