This documentation is archived and is not being maintained.

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

WithEvents refreshEvents_Event1 As RefreshEvents_Event
Function refreshEvents_Event1_BeforeRefresh(Cancel As Boolean) As Void
	Handles refreshEvents_Event1.BeforeRefresh
End Function

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.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms