QueryTable.AfterRefresh Event (Excel)
Occurs after a query is completed or canceled.
Syntax
expression .AfterRefresh(Success)
expression A variable that represents a QueryTable object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Success |
Required |
Boolean |
True if the query was completed successfully. |
Return Value
Nothing
Example
This example uses the Success argument to determine which section of code to run.
Private Sub QueryTable_AfterRefresh(Success As Boolean)
If Success Then
' Query completed successfully
Else
' Query failed or was cancelled
End If
End Sub