title: Web Query VBA Refresh
body: <p>If I have a web query connection established, what's the best way to update the URL and refresh the connection with VBA?</p>
  
  <p>Here is basically what I want to do:</p>
  
  <pre><code>Sub RefreshWebQuery()
  
      Dim request As String
      request = 'some url constructed by concatenating cell values
  
      'set command text of my web query as request
      'update my query table
  
  End Sub
  </code></pre>
  
  <p>I've seen various methods online but none are concise/worked for me.</p>
  
  <p>Thanks in advance for your help.</p>