Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. The Add method allows you to specify a template for the new workbook
Sub add()
     Set myWorkbook1 = Workbooks.Add(Template:="C:\Data\SalesData.xlsx")
End Sub