Hi,

Just an idea.. I assume you have this file as a template and then you want to save them as new file with unique name. I have two choices
1. you have one file as database for running number and retrieve the running number to be used as file name
2. you have some cell in the workbook that can identify the unique number and use this for saving new file name

here is one useful method you may follow or modify
http://blogs.office.com/b/microsoft-...-in-excel.aspx