Suggestion before doing any work on the code.

Do you think it might be advantageous to have the list of filenames and the
macro in a separate workbook.

My reasons for this a-

1. The list of file names are probably not required in the new workbooks.

2 It is easy to open another workbook using code and save it as a new file
name.

3. You will not have the macro in the new workbooks and if others are using
them then they do not have the hassle of approving the macros every time they
are opened. (Unless of course you already have other macros in the workbook
in which case this suggestion is redundent.)

Think about it and post your answer.

--
Regards,

OssieMac


"jhong" wrote:

Hi Everyone,

Good Day!

Hope you can share some codes with my current problem. I have a
template with 5 sheets on it. I update this template once in while,
once updated i recreate close to 20 workbooks out of this template
with different file name when save.

I am thinking, is it possible if i have another "name sheet" on my
template with the list of all file names i need to recreate then run a
macro to duplicate my workbook template and get the file name on the
name sheet tab and the macro will run up to the last cell with name on
that name sheet.

Hope i explain it clear :) Thanks in Advance.

Tops