title: refreshes two queries (one by one) with a button in VBA
body: <p>I've created a button with VBA which has the function to refresh two queries when you click on it.</p>
  <pre><code>MsgBox &quot;please be patient, this operation may take several minutes.&quot;
  ThisWorkbook.Connections(&quot;Query - Load&quot;).Refresh
  ThisWorkbook.Connections(&quot;Query - Start&quot;).Refresh
  MsgBox &quot;opperation successfully completed &quot;
  </code></pre>
  <p>But I don't know how to wait until the first query is over and then launch the second one.
  Currently both queries are refreshed at the same time and as you can imagine the second query uses the data created by the first one.</p>
  <p>I was thinking of creating 2 buttons for each query but I also don't know how to indicate when the first operation ends.</p>
  <p>thanks for your help</p>