RefreshEvents_Event.BeforeRefresh Event
Occurs before any refreshes of the query table. This includes refreshes resulting from calling the Refresh method, from the user's actions in the product, and from opening the workbook containing the query table.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)
Usage
WithEvents refreshEvents_Event1 As RefreshEvents_Event
Function refreshEvents_Event1_BeforeRefresh(Cancel As Boolean) As Void
Handles refreshEvents_Event1.BeforeRefresh
End Function
Syntax
Event BeforeRefresh As RefreshEvents_BeforeRefreshEventHandler
event RefreshEvents_BeforeRefreshEventHandler BeforeRefresh;
event RefreshEvents_BeforeRefreshEventHandler^ BeforeRefresh;
void add_BeforeRefresh(RefreshEvents_BeforeRefreshEventHandler handler);
void remove_BeforeRefresh(RefreshEvents_BeforeRefreshEventHandler handler);
In JScript, you can handle the events defined by a class, but you cannot define your own.
Platforms
Development Platforms
Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000
Target Platforms
See Also
Reference
RefreshEvents_Event Interface
Microsoft.Office.Interop.Excel Namespace