scheduling problems
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? |
scheduling problems
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 smilingangel wrote: 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? |
All times are GMT +1. The time now is 09:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com