Updating or Auto Saving a file every hour

[Olyn01]

Hi! I have an excel file that is saving every day. I could save it an hour but not 'every' hour because of the error with the filename. Is there a way to just have a file which is updating every hour until it reaches a whole day and automatically save it with the same file name? Thanks

 

[Yongle]

Try ...

In ThisWorbook Module

Sub Workbook_Open()
    Call SaveMe
End Sub

In STANDARD module

Sub SaveMe()
    Const fPath = "C:\Folder\SubFolder[COLOR=#ff0000]\[/COLOR]"         'end path with  [COLOR=#ff0000]\[/COLOR]
[I][COLOR=#006400]'unique name[/COLOR][/I]
    Dim fName As String
    fName = Format(Date, "YYMMDD_") & Round(Timer, 0) & "_" & ThisWorkbook.Name

    ActiveWorkbook.SaveCopyAs fPath & fName

[COLOR=#006400][I]'call again in one hour[/I][/COLOR]
    Application.OnTime Now + TimeValue("01:00:00"), "SaveMe"
End Sub