refreshing a querytable connection on opening a worksheet VBA

[star1984]

hi,
I have the following code which is updating the connection held for all querytables in my worksheet.
This works fine however I also want to automatically get the querytabke to refresh - ie in Excel the user goes to Data>Connections> and presses the refresh button. Is there a way to access this refresh method through VBA code. I am thinking something along the lines of
Worksheet.QueryTables.Item(itemcount).Connection.Refresh but this doesn't work

For Each Worksheet In ThisWorkbook.Worksheets
itemcount = 0
For Each Item In Worksheet.QueryTables
itemcount = itemcount + 1
Worksheet.QueryTables.Item(itemcount).Connection = SQLConn
Next
Next

Any suggestions?

 

[star1984]

By recording a macro and viewing the autogenerated code I have found that line I want is

ActiveWorkbook.Connections("Connection").Refresh

However - "Connection" is hardcoded - if I have multiple connections on one worksheet I wont want to hardcode this I'll want the connectionname. Is there a way to read the name property of a connection?