Create Copy of workbook using macro and Name them as per list

Hi,

I am wondring if it is poossible to use a macro to create a copy of workbook while we use a list to name the new created book.

Example: Column A of "sheet1" of workbook "Masterfile.xlsm" contains unique numbers that I want to use for naming new workbooks.(0123,0456,0789,).
Workbook I want to use create copy is "user.template.xlsm" on a path say "C:\Documents and Settings\Desktop\Database" and should be named as 0123,0456,0789 etc.

How the code should look like?? I have codes that copy sheet data but I just want to make a complete new workbook. This will save me creating 900 copies every 1st of the month..

Maybe:

Please Login or Register  to view this content.

Hi John,

This works great for me. Thanks. I just have another issue.. I have 2 columns in Workbooks("Masterfile.xls").Sheets("Sheet1")
"A:A" has names that is used to name new files and column B:B has a value against each name that should populate in that new file at time of ccreation in cell say "B5".
Also the sheet name should be same as file name in the new file . How can I reach here..