Hi everyone! I hope everyone is having a good day. I am trying to copy a template workbook (with multiple sheets) multiple times and rename based on a name list. I found the following code, edited it and tested it. But I don't know how to add the template in? I don't just want an empty workbook and rename it. I want it to be copied from an existing template. Many thanks in advance if anyone can help.
VBA Code:
Sub CopyWorkbook()
Dim wbName as String
For i = 1 to 10
wbName = Cells(i, 1).Value
Workbooks.Add
ActiveWorkbook.SaveAs Filename:="C:\Users\Desktop\" & wbName & ".xlsx"
Close
Next i
End Sub