title: Definitive file path to a cell location using Excel VBA
body: <p>I am wondering how to define the specific file path to a cell location using Excel VBA? I am trying to load a value to <code>nCount</code> which is the count in another file in a defined location. So more like assigning the value from a cell to <code>nCount</code>.</p>
  
  <pre><code>nCount = "G:\ABC\[FILE FOR 2016-2017.xlsx]Master!$A$1"
  </code></pre>
  
  <p>It gives me an error:</p>
  
  <blockquote>
    <p>Run-time error '13:"; "Type Mismatch</p>
  </blockquote>