Jul 07 2021 10:58 PMSolution
It's simple code and more efficient than that, what more could you need! :))
VBA code should be placed in "This Workbook".
Option Explicit Private Sub Workbook_Open() Backup _ intHrs:=6, _ 'insert the time (in hours) after how many hours it should backup each time strPathIn:="\\NAS3\Team\Own\Filename_Backup_2022\" 'insert the path where the backup should be saved. End Sub
I would be happy to know if I could help.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Jul 07 2021 11:07 PM