title: How to name the connection used by a QueryTable
body: <p>My current code:</p>
  
  <pre><code>ConnectionName = "testCon"
  With ActiveSheet.QueryTables.Add(Connection:= _
      "URL;http://test/test?values=[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]~[]&amp;format=csv" _
      , Destination:=Range("$D$1"))
      .Name = ConnectionName
  End With
  </code></pre>
  
  <p>This results in a new connection being created, named "Connection", and if the process is repeated "Connection1" is created, then "Connection2" and so on. Is there any way to name the connection?</p>
  
  <p>the <code>.Name</code> parameter seems to refer to the data range name, rather than connection name.</p>