OLEDBConnection.RobustConnect Property
Returns or sets how OLE DB connection connects to its data source. Read/write XlRobustConnect.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property RobustConnect As XlRobustConnect
Get
Set
'Usage
Dim instance As OLEDBConnection
Dim value As XlRobustConnect
value = instance.RobustConnect
instance.RobustConnect = value
XlRobustConnect RobustConnect { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlRobustConnect
XlRobustConnect
Remarks
If you use robust connectivity, when Microsoft Excel is unable to establish a connection using the workbook connection information, Excel will check if the workbook connection has a path to an external connection file. If it does, Excel will open the external connection file and try to connect using the information contained in the external connection file. If a connection can be established after using the external connection file, Excel will then update the workbook's connection object.
This provides robust connectivity in scenarios where an Information Technology Department maintains and updates connections in a central place, permitting a user's workbook to automatically fetch those updates whenever the previous version of the connection (cached within the workbook) fails.