title: VBA: Run-time error 3220 “Supplied provider is different from the one already in use”
body: <p>I get the error message</p>
  
  <pre><code>Run-time error 3220 "Supplied provider is different from the one already in use"
  </code></pre>
  
  <p>When I try to run the following command in a file that I have received</p>
  
  <pre><code>datConnection.Open (Provider=Microsoft.Jet.OLEDB.4.0;Data Source='C:\Users\Laptop\Desktop\Excel files Test\Macros\example 1.xlsx';Extended Properties='Excel 8.0;HDR=Yes;IMEX=1')
  </code></pre>
  
  <p>Any idea why I get the error and how I can change it to make it work?</p>
  
  <p>I don't know if it is relevant but I have</p>
  
  <pre><code>Windows 7 x64
  Excel 2013
  </code></pre>