title: Having a user choose where to save an Excel workbook
body: <p>I currently have a macro that will read data, print a results sheet, and then copy the data and results to a different workbook that is then saved as a regular .xlsx file as opposed to .xlsm. My code to save that book is as follows:</p>
  
  <pre><code>NewBook.Activate
  ActiveWorkbook.SaveAs Filename:=NotNum &amp; " Make Ready", _
       FileFormat:=xlOpenXMLWorkbook
  CTLBook.Activate
  </code></pre>
  
  <p>It brings up the new workbook I want to save, saves it under the name NotNum (a changing variable) and the string "Make Ready" and then brings back my original workbook so I can manipulate that further.</p>
  
  <p>The save function works perfectly however it saves to my default folder (currently 'My Documents'). Is there a way I can code something before or after the save function that allows the user to choose where to save the document? Thanks</p>