QueryTable.RobustConnect Property (Excel)
Returns or sets how the query table connects to its data source. Read/write XlRobustConnect.
Syntax
expression .RobustConnect
expression A variable that represents a QueryTable object.
Remarks
XlRobustConnect can be one of these XlRobustConnect constants. |
xlAlways . The query table always uses external source information (as defined by the SourceConnectionFile or SourceDataFile property) to reconnect. |
xlAsRequired. The query table uses external source information to reconnect, using the Connection property. |
xlNever. The query table never uses source information to reconnect. |
If you import data by using the user interface, data from a web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object.
If you import data by using the object model, data from a web query or a text query must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable.
You can use the QueryTable property of the ListObject to access the RobustConnect property.