scheduling problems

S

smilingangel

I need help with finding a way to save my weekly schedule, to a different
name, and also how to clear it each week. Can anyone help?
 
J

J.Evans.1970

You could add a button and then add some code behind the button. Maybe
like so:

Private Sub CommandButton1_Click()
Dim sNewFileName as String
sNewFileName = "C:\File_" & Format(Date, "YYYYMMDD") & ".xls"
ThisWorkbook.SaveCopyAs sNewFileName
Sheet1.Range("B2:B20").ClearContents
End Sub
 
Top