title: Opening a workbook with ADODB connection in a second session in Excel
body: <p><strong>The problem only exists when I open the workbook in a new Excel session and there are other sessions open before</strong></p>
  
  <p><strong>No problem when I open the workbook in the same Excel session as the first Excel session</strong></p>
  
  <p>The problem is that something breakes down:</p>
  
  <pre><code>Set cn = New ADODB.Connection
  Set rs = New ADODB.Recordset
  
  strFile = ThisWorkbook.FullName
  strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp; strFile _
  &amp; ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";"
  
  cn.Open strCon
  </code></pre>
  
  <p>When the last line i.e. <em>cn.open strCon</em> above is executed there opens a read only version of the workbook in the first Excel session and everything breakes down.</p>
  
  <p>This is very strange because it is another session in which the read only version pops up in.</p>
  
  <p>I have seen some people complaining about this issue without a solution e.g.:</p>
  
  <p><a href="http://www.ozgrid.com/forum/showthread.php?t=76156" rel="nofollow">http://www.ozgrid.com/forum/showthread.php?t=76156</a></p>