Workbooks.Add ActiveWorkbook.SaveAs “<C:\insertYourFilePathHere\<name for your new workbook>.xls>”
‘example that creates a new workbook called myWorkbook in the Downloads Folder Workbooks.Add ActiveWorkbook.SaveAs "C:\Users\glestrade\Downloads\myWorkbook.xls"
To find a file path for a file, click here.