Workbook.Connections (Excel)

Establishes a connection between the workbook and an ODBC or an OLEDB data source and refreshes the data without prompting the user.

Dim cnnsConnections As Connections
Set cnnsConnections = ActiveWorkbook.Connections