WorkbookConnection.Refresh method (Excel)
Refreshes a workbook connection.
Syntax
expression.Refresh
expression A variable that represents a WorkbookConnection object.
Remarks
If the DisplayAlerts property is False, dialog boxes are not displayed, and the Refresh method fails with the Insufficient Connection Information exception.
A refresh failure for one connection will not have any impact on refresh operations for the other connections.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.