title: ADO Connection conflicting with other excels (very weird issue)
body: <p>I created quite a comprehensive End User application in VBA excel the last two months which automated the whole reporting chain based on a daily dump of data in an excel sheet. </p>
  
  <p>All worked fine until the tool went live. When launching my code on a operation desk, sometime the queries on the data dump returns no results.
  This only happens when the tool was not opened as a first excel instance.</p>
  
  <p>So, when another excel tool is open first, my tool:
        - Returns no results
        - An another instance of my tool is opened in read-only</p>
  
  <p>This happens as well on windows 2007 &amp; 2010 and on Win XP &amp; Windows 7.
  It opens the other excel on following line (where the issue is situated:
      'adoConn.Open sConnString'</p>
  
  <p>Below my code:</p>
  
  <pre><code>Public Function createConnection() As ADODB.Connection
  
  Dim DbPath As String
  Dim sConnString As String
  Dim adoConn As New ADODB.Connection
  
  
  DbPath = ThisWorkbook.FullName
  
  'Define connection String
  'http://www.codeguru.com/csharp/.net/net_asp/tutorials/article.php/c19307/Whats-in-an-ADO-Connection-String.htm
  sConnString = "Provider=MSDASQL.1;DSN=Excel Files;DBQ=" &amp; DbPath &amp; ";HDR=Yes';"
  
  'Open the connection
  adoConn.Open sConnString
  
  'Return the connection
  Set createConnection = adoConn
  
  End Function
  </code></pre>