Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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