title: ExecuteExcel4Macro & update values dialog box
body: <p>I'm currently coding a small VBA tool in order to quickly sort files according to some data inside. As an example, I have a &quot;To be sorted&quot; folder with some files in it, lets say &quot;File1.xls, File2.xls&quot; and so on.</p>
  <p>To read data in &quot;FileX.xls&quot;, I use <code>ExecuteExcel4Macro</code> (with the range and filename set properly), then I can use this data to apply filters and move files in other directories.</p>
  <p>My code works fine with local files, but when I try to run it on my server (the tool aims at sorting files stored on the server), a dialog box &quot;Update values&quot; appears when I use <code>ExecuteExcel4Macro</code>.</p>
  <p>From here, I have to options:</p>
  <ul>
  <li>manually opening each file before running the macro (I have like 250 files to sort so...)</li>
  <li>pressing cancel on the dialog box which causes the plugin to crash (type mismatch error)</li>
  </ul>
  <p>Here is the portion of code that bothers me</p>
  <pre><code>For Each fsoFile In fsoParentFol.Files
  
      'I only want to sort .xls files
      If Right(fsoFile.Name, 4) = &quot;.xls&quot; Then
          'On active le workbook actuel
          strRef = &quot;'[&quot; &amp; fsoFile.Name &amp; &quot;]&quot; &amp; &quot;Sheet1&quot; &amp; &quot;'!&quot;
  
          'this is the data I want to retrieve ... and this is where the dialog pops up
          projectName = ExecuteExcel4Macro(strRef &amp; rngProjectName.Address(1, 1, xlR1C1))
          
          'some more code goes here but is irrelevant
      End If
  Next fsoFile           
  </code></pre>
  <p>So my question is: how can I disable this dialog or, if it's a bad idea, are there other clean methods (I don't want to open each workbook, even with screenupdate turned off) that could solve my issue?</p>
  <p><code>DisplayAlerts = False</code> doesn't solve the problem. And again, the program runs fine without this dialog.</p>
  <p>I've of course tried to research online my problem first before posting here, but even subjects like <a href="https://stackoverflow.com/questions/26722693/prevent-the-update-values-dialog-box-from-opening-every-time-a-cell-with-a-li">this one</a> aren't solutions to my problem.</p>