What is the syntax to create a new workbook?

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.

Advertisements