title: Why can't I define my workbook as an object?
body: <p>Why can't I define a workbook either of these ways?  (I have the range bit in there just for a quick test.)  How do I fix it?</p>
  
  <p>This produces a <code>"Compile Error: Type Mismatch"</code></p>
  
  <pre><code>Sub Setwbk()
  
      Dim wbk As Workbook
  
      Set wbk = "F:\Quarterly Reports\2012 Reports\New Reports\ _
             Master Benchmark Data Sheet.xlsx"
  
      Range("A2") = wbk.Name
  
  End Sub
  </code></pre>
  
  <p>And this creates a <code>"Runtime Error '91': Object variable or with block variable not set"</code></p>
  
  <pre><code>Sub Setwbk()
  
      Dim wbk As Workbook
  
      wbk = "F:\Quarterly Reports\2012 Reports\New Reports\ _
            Master Benchmark Data Sheet.xlsx"
  
      Range("A2") = wbk.Name
  
  End Sub
  </code></pre>
  
  <p>What am I missing here?  I've been hammering away at VBA for a month, gotten pretty sophisticated, but this has me stumped.  I'm missing something elemental.<br>
  I just want to define a workbook so I don't have to type it all out!</p>