renaming worksheet from within macro

[Guest]

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

 

[Guest]

Private Sub Macro1( )
If Not Listbox1.Text = "" Then
ActiveWorkbook.SaveAs Filename:= Listbox1.Tex
End Sub

 

[Guest]

To Chris
Thanks for the help. To be honest i don't really know how to use this info. Where can i learn more about this. Is this stuff actually done inside the worksheet? Don't expect you to teach me this, but would like some help with where to learn. I get computer stuff pretty quickly. Thanks again, Mark