PivotCache.CommandText Property (Excel)
Returns or sets the command string for the specified data source. Read/write Variant.
Syntax
expression .CommandText
expression An expression that returns a PivotCache object.
Remarks
For OLE DB sources, the CommandType property describes the value of the CommandText property.
For ODBC sources, setting the CommandText causes the data to be refreshed.