title: VBA EXCEL update cell in another workbook without opening the workbook
body: <p>I have a directory with list of Workbooks, I want to loop through them <em>withouth</em> opening them and update a Cell in a certain Sheet</p>
  
  <p>I have tried to use </p>
  
  <pre><code>Dim wb As Workbook
  Set wb = Workbooks("Z:\dir\bla.xls") 'THIS WILL COME TRHOUGH WHEN I LOOP 
  Set ws2 = wb.Sheets("TestSheet") 'SHEET NAME
  
  Set CurCell_2 = ws2.Range("A1")
  CurCell_2.Value = 5
  </code></pre>
  
  <p>The Problem comes it only works when I have the Workbook already open. I can use: </p>
  
  <pre><code>Workbooks.Open
  </code></pre>
  
  <p>But then It opens up in the background and takes to long to run through them all.</p>
  
  <p>Can anyone help please</p>