title: ExecuteExcel4Macro to get value from closed workbook
body: <p>I found this bit of code and thought it might be good to use if I just need to pull one value from a closed sheet. </p>
  
  <pre><code>strInfoCell = "'" &amp; strPath &amp; "[" &amp; strFile &amp; "]Sheet1'!R3C3"
  myvalue = ExecuteExcel4Macro(strInfoCell)
  </code></pre>
  
  <p>When I run this code I get a value for <code>strinfocell</code> of </p>
  
  <p><code>'C:\Users\my.name\Desktop[QOS DGL stuff.xlsx]Sheet1'!R3C3</code></p>
  
  <p>But when I run the code a dialogue pops up, showing desktop files with "<code>QOS DGL suff</code>" showing.   </p>
  
  <p>What's causing this, why is it not just pulling back the data as expected? </p>
  
  <p>I know the path and file name are right, because if I copy them from the debug output and paste them in to <code>start&gt;&gt;run</code> then the correct sheet opens.</p>
  
  <p>I know that <code>Sheet1</code> (named: <code>ACL</code>), does have a value in <code>cells(3,3)</code></p>