OLEDBConnection.AlwaysUseConnectionFile property (Excel)
True if the connection file is always used to establish a connection to the data source. Read/write Boolean.
Syntax
expression.AlwaysUseConnectionFile
expression A variable that represents an OLEDBConnection object.
Remarks
When this property is True the connection file will always be used to establish the connection to the data source. If the connection embedded within the workbook is different from the external connection file, the embedded connection will be ignored and the external connection file will be the only version considered.
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.