title: How to reference a cell in another workbook that is closed (using INDIRECT function)?
body: <p>I am trying to reference a cell in a closed workbook by using the indirect function. I have tried the following:</p>
  
  <pre><code>= INDIRECT("'C:\Users\Ross\Desktop\["&amp;A1&amp;"]" &amp; B3 &amp; "'!$A$2")
  </code></pre>
  
  <p>A1 is my file name, B3 is sheet name, A2 is cell reference. </p>
  
  <p>I tried for awhile to get it to work by using other stackoverflow questions but it keeps throwing a #ref error. </p>
  
  <p>I would like to use the indirect function but if VBA is required I'd love to see what you did to make it work.</p>
  
  <p>Any and all help is appreciated!</p>
  
  <p><img src="https://i.stack.imgur.com/q8DZG.png" alt="A picture of my workbook that I am using is attached"></p>