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..