title: access value (content) of a named cell in Excel VBA
body: <p>This</p>
  
  <pre><code>Dim WB As Workbook
  Set WB = Workbooks.Open("foo\bar.xlsx", , True)
  Debug.Print (WB.Names("named_cell").Value)
  WB.Close (False)
  </code></pre>
  
  <p>returns</p>
  
  <pre><code>='Sheet'!$C$377
  </code></pre>
  
  <p>instead of the value in the cell <code>C377</code>.</p>
  
  <p>How can I receive the value of the cell instead?</p>