This documentation is archived and is not being maintained.

CancelRefresh Method [Excel 2003 VBA Language Reference]

Office 2003

Cancels all background queries for the specified query table. Use the Refreshing property to determine whether a background query is currently in progress.

expression .CancelRefresh

expression Required. An expression that returns a QueryTable object.

Example

This example cancels a query table refresh operation.

With Worksheets(1).QueryTables(1)
    If .Refreshing Then .CancelRefresh
End With
		


Applies to | QueryTable Object


Show: