title: How can I change the file path of a Workbook in VBA?
body: <p>So I have a Workbook that is being saved. It is being saved under a name from two cells in a different workbook. As of right now, it saves automatically to the documents folder on my computer. I would like to change this to a folder of my choosing. I'm guessing this should be pretty straight-forward. Here's my code so far:</p>
  
  <pre><code>    Dim name As String
  
      name = Workbooks("Transfer Template").Sheets("Sheet1").Range("B1").Value &amp; "_" &amp; Workbooks("Transfer Template").Sheets("Sheet1").Range("B4").Value
      Windows("Protected_Form.xls").Activate
      ActiveWorkbook.SaveAs Filename:=name
  </code></pre>
  
  <p>Thanks!</p>