|Excel Developer Reference|
Version Added: Excel 2007
expression A variable that represents an ODBCConnection object.
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.
|Robust connectivity isn’t secure. If you create a connection on your computer and use it in a workbook and then send someone the workbook, that person will be able to see the path to the connection file on your computer. It is a good idea to remove the connection file information from the workbook before you send the workbook to someone else.|