tanmaysingh
New Member
- Joined
- May 15, 2015
- Messages
- 3
New to EXCEl VBA , but this community is known to help a newbie become pro users 
My requirement is simple.
I ve a list of filename in column A:A200 of Sheet1 of Boook1.
I ve an excel Book2 which is a readymade template with 6 sheets.
I Need to create or rather replicate this excel Book2, by changing the file name of the template excel
to the names i have in column A:A200 of the Book1, sheet1.
Also a small functionality would be that the same name(name of the excel or the name present in
the column A should be added to Sheet1, cell B5 of the New sheet.
So basically i have to make copies of an excel template and rename them according to my list
and also change a value in the new sheet as the name of the excel.
Am sure many users would have wanted this simple functionality, so any small VBA code, or
reference to any code already present in the forum would be helpful.
My requirement is simple.
I ve a list of filename in column A:A200 of Sheet1 of Boook1.
I ve an excel Book2 which is a readymade template with 6 sheets.
I Need to create or rather replicate this excel Book2, by changing the file name of the template excel
to the names i have in column A:A200 of the Book1, sheet1.
Also a small functionality would be that the same name(name of the excel or the name present in
the column A should be added to Sheet1, cell B5 of the New sheet.
So basically i have to make copies of an excel template and rename them according to my list
and also change a value in the new sheet as the name of the excel.
Am sure many users would have wanted this simple functionality, so any small VBA code, or
reference to any code already present in the forum would be helpful.
