Compartilhar via

_Application.DeferAsyncQueries Property

  • Artigo

Gets or sets whether asychronous queries to OLAP data sources are executed when a worksheet is calculated by VBA code. Read/write.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property DeferAsyncQueries As Boolean
    Get
    Set
'Usage
Dim instance As _Application
Dim value As Boolean

value = instance.DeferAsyncQueries

instance.DeferAsyncQueries = value

bool DeferAsyncQueries { get; set; }

Property Value

Type: System.Boolean
Boolean

Remarks

Setting the DeferAsyncQueries property to True prevents any asynchronous queries form executing until the CalculateUntilAsyncQueriesDone() method is called.

See Also

Reference

_Application Interface

_Application Members

Microsoft.Office.Interop.Excel Namespace