Share via

PivotCache.CommandText Property

  • Article
Excel Developer Reference

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.

See Also