AfterRefresh Event [Excel 2003 VBA Language Reference]

  • Article

Occurs after a query is completed or canceled.

Private Sub QueryTable_AfterRefresh(SuccessAs Boolean)

SuccessTrue if the query was completed successfully.

Example

This example uses the Success argument to determine which section of code to run.

Private Sub QueryTable_AfterRefresh(Success As Boolean)
    If Success
        ' Query completed successfully
    Else
        ' Query failed or was cancelled
    End If
End Sub

Applies to | QueryTable Object

See Also | BeforeRefresh Event | QueryTable Object Events | Using Events with the QueryTable Object