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
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?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'