title: Setting value of active workbook in Excel VBA
body: <p>I for now have my workbook set up this way, in where the workbook is hard coded into the Set command, I am wondering if there is a way of doing this so I can have it where it is fluid? So no matter where this code is place (in another workbook) the code will adapt to it's new surroundings.</p>
  
  <p>Does this make sense? </p>
  
  <p>Below is what I am using now, what I'd like to have it do is for the <code>ActiveWorkbook</code> or something of the sort be used instead. Since this will be set at the beginning of the code and not the middle.</p>
  
  <p><code>Set wbOOR = Application.Workbooks("Open Order Report.xlsm")</code></p>