title: VBA Create a new workbook with a button click
body: <p>I'm trying to create a macro that creates a new workbook when pressing a button on the already existing workbook. I would like to save the newly created workbook in the same folder as the exiting workbook and give it a new name? Could somebody help me please?</p>
  
  <p>Thank you very much in advance!</p>
  
  <p>That's the code I have until now but it doesn't work as I want it (object not found and doesn't save it in the same folder):</p>
  
  <pre><code>Sub CreateNewWorkBook()
  
  'Adding New Workbook
  Workbooks.Add
  'Saving the Workbook
   ActiveWorkbook.SaveAs Filename:=thisWb.Path &amp; "\Test.xls"
   ActiveWorkbook.Close savechanges:=False
  
  End Sub
  </code></pre>