Could anybody help me create a solution for:

I have created a excel workbook. This is a masterworkbook in which
calcualtions are being provided. Eaqch time a user uses this workbook
he should make a copy of this workbook to archive it. In the workbook i
have added the name of the file i want it to be saved as.
Does anybody have a suggestion for visual basic code?


---
Message posted from http://www.ExcelForum.com/