I have a daily bookwork sheet that containes employee names. This file changes as employees come and go. I am writing a macro so that a person doing my daily books can select the day of the month from a list in excel. When they select the day, it will copy the original file... is there a way to do a "save as" from inside a macro. ex. on june 1st, hit the excel macro for that day, it will bring up the master file, rename it and save it as june 1. Doing the same with each day during the month. Therefore the master file with names can change to affect all days forward.

Open to any suggestions
Thanks for the help, Mark