I need help, my problem is, I need to save a excel wordbook file every Monday morning around 10:00 am and save this file with the day added to his is to the name or change the file name for the date, this is to keep a weekly record
Printable View
I need help, my problem is, I need to save a excel wordbook file every Monday morning around 10:00 am and save this file with the day added to his is to the name or change the file name for the date, this is to keep a weekly record
Are you looking to save the active file or some other one. Might it be open by anyone else? To what extent do you wish to auitomate this?
the active one, I need a Macro to do this action
Try
[VBA]
Sub Copies()
If Weekday(Date) = 2 Then
Application.OnTime TimeValue("10:00:00"), "MakeCopy", TimeValue("11:00:00")
End If
End Sub
Sub MakeCopy()
ActiveWorkbook.SaveCopyAs ActiveWorkbook.Path & "\" & _
Split(ActiveWorkbook.Name, ".")(0) & Format(Date, "-yymmdd") & ".xls"
End Sub
[/VBA]