Vba code

[perka68]

I have a Workbook named SR.xltm with a template sheet called Mall. This sheet contains a table with empty cells for a user to fill in. The problem is that i want to put this Workbook on a usb stick and run a vba macro that creates a new instance of the file in any computer I put the usb stick in. I want the macro to create 52 copies of the template sheet in the new workbook on the computer. These 52 copies will be named with the current year_w00, where the w stands for week and 00 is the week number in integer. I got it to work in the same workbook but I would like it work from separate file on a usb stick. So just make a new excel file called SR.xlsx with 52 sheets ( copies of the sheet Mall) named with current year and w (week) 00 (as week number 01-52)
Thankful for any help i can get.
Best regards
Per-Erik