title: Best option to refresh a single query using VBA
body: <p>I have a workboook with 4-6 queries and I just would like to refresh 1 of the 6 with VBA. My question is, am I using the fastest option below?</p>
  
  <p>And nope, I don't want to use the Refresh All / Refresh button within Excel, I needed to include this in a sub.</p>
  
  <p>CODE:</p>
  
  <pre><code>    ThisWorkbook.Connections("Query - Raw").OLEDBConnection.refresh
  
      ' THESE ALSO WORK
      ' ActiveWorkbook.RefreshAll
      ' Selection.ListObject.QueryTable.refresh BackgroundQuery:=False
  </code></pre>
  
  <p>These don't work:</p>
  
  <pre><code>    ActiveWorkbook.Connections("Raw").refresh
      ThisWorkbook.Connections("Raw").refresh
  </code></pre>
  
  <p>Thank you for the kind answers in advance.</p>