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 property causes the data to be refreshed.

Support and feedback

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.