How to copy template with Excel VBA and rename it with variable

In this video, we will copy template with Excel VBA, user will name it automatically and save it at any location.
First create new workbook in excel vba
select targeted workbook which is to be copied
copy the workbook and save it in newly created excel workbook
user will specify the path and name of the workbook
save the workbook and close it
verify newly created workbook save at specified location