Hi Melissa,

Have you tried

ActiveWorkbook.Connections("<connection name>").Refresh
That allows you specify a named Connection.

Hope this helps.