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.