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

将指定查询表或数据透视表的刷新计时器重置为上次使用**RefreshPeriod** 属性设置的间隔。Resets the refresh timer for the specified query table or PivotTable report to the last interval that you set by using the RefreshPeriod property.

语法Syntax

表达式ResetTimerexpression.ResetTimer

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

示例Example

此示例重新设置当前活动工作表上第一张查询表的刷新计时器。This example resets the refresh timer for the first query table on the active worksheet.

ActiveSheet.QueryTables(1).ResetTimer

支持和反馈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.