ODBCConnection.AlwaysUseConnectionFile property (Excel)
True if the connection file is always used to establish connection to the data source. Read/write Boolean.
Syntax
expression.AlwaysUseConnectionFile
expression A variable that represents an ODBCConnection object.
Remarks
When this property is True, the connection file will 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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for