CancelRefresh 方法 (Excel)QueryTable.CancelRefresh method (Excel)

取消指定查询表的所有后台查询。Cancels all background queries for the specified query table. 使用**刷新** 属性来确定当前是否正在进行后台查询。Use the Refreshing property to determine whether a background query is currently in progress.

语法Syntax

表达式CancelRefreshexpression.CancelRefresh

_表达式_一个代表查询表对象**** 的变量。expression A variable that represents a QueryTable object.

示例Example

本示例取消查询表的刷新操作。This example cancels a query table refresh operation.

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

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.