WorkbookConnection.Refresh Method
Refreshes a workbook connection.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub Refresh
'Usage
Dim instance As WorkbookConnection
instance.Refresh()
void Refresh()
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.