title: Referencing value in a closed Excel workbook using INDIRECT?
body: <p>I want to refer to a cell value in another <strong><em>closed</em></strong> workbook with a formula (not VBA!). The <strong>Sheet name is stored as a variable</strong> (in the following example, C13 is "Sheet2").</p>
  
  <p>If the other file is open, then following works:</p>
  
  <pre><code>=INDIRECT("[myExcelFile.xlsm]" &amp; C13 &amp; "!$A$1")
  </code></pre>
  
  <p>If the file is closed, the above formula doesn't work, as there is no absolute path given. But I got it work with following (give attention to ' instead of ":</p>
  
  <pre><code>='C:\data\[myExcelFile.xlsm]Sheet2'!$A$1
  </code></pre>
  
  <p>Now I want to replace the hardcoded "Sheet2" with a <strong>dynamic referenced</strong> value, means with C13 (as seen in the first code snippet).</p>
  
  <p>Does anybody know a solution without using VBA or other libraries?</p>