Skip to content

Latest commit

 

History

History
35 lines (20 loc) · 836 Bytes

Excel.PivotCache.CommandText.md

File metadata and controls

35 lines (20 loc) · 836 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotCache.CommandText property (Excel)
vbaxl10.chm227087
vbaxl10.chm227087
Excel.PivotCache.CommandText
07921bda-74fe-2a41-15f7-16068ce49a31
05/03/2019
medium

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.

[!includeSupport and feedback]