title: Difference between Thisworkbook.name and Activeworkbook.name in VBA
body: <p>Is there any difference between Thisworkbook and ActiveWorkbook.</p>
  
  <p>Example code :</p>
  
  <pre><code>  Sub workbook_name()
       MsgBox Thisworkbook.name
    End Sub
  
  
  
   Sub active_name()
       MsgBox Activeworkbook.name
    End Sub
  </code></pre>
  
  <p>Both will return the same output, </p>
  
  <p>Is there any other instances where we have to use particularly ThisWorkbook where ActiveWorkbook doesn't work</p>