here's the code:
Dim oFS, backup_dir_w, backup_dir_m, backup_dir_d, backup_sorgDim timedir, timedir_del, date_7'# SET YOUR PATHS HERE ####backup_sorg = "C:\source_folder"backup_dir_d = "C:\destination_folder\Daily\"backup_dir_w = "C:\destination_folder\Weekly\"backup_dir_m = "C:\destination_folder\Monthly\"if right(backup_sorg, 1) = "\" then backup_sorg = Left(backup_sorg, (Len(backup_sorg) - 1))end ifif right(backup_dir_d, 1) <> "\" then backup_dir_d = backup_dir_d & "\"end ifif right(backup_dir_w, 1) <> "\" then backup_dir_w = backup_dir_w & "\"end ifif right(backup_dir_m, 1) <> "\" then backup_dir_m = backup_dir_m & "\"end ifSet oFS = CreateObject("Scripting.FileSystemObject")'##### DAILY BACKUP FOLDER ####timedir = backup_dir_d & Year(Date) & PadZero(Month(Date)) & PadZero(Day(Date)) & "\"oFS.CreateFolder(timedir)'#### DAILY FOLDER ####oFS.CopyFolder backup_sorg, timedir'#### DELETE 7 DAYS OLD BACKUP ####date_7 = (DateAdd("d",-7,now()))timedir_del = backup_dir_d & Year(date_7) & PadZero(Month(date_7)) & PadZero(Day(date_7))If oFS.FolderExists(timedir_del & "\") Then oFS.DeleteFolder timedir_delEnd If'################################timedir = Left(timedir, (Len(timedir) - 1))'#### WEEKLY BACKUP ####if WeekDay(Now()) = 6 then oFS.CopyFolder timedir, backup_dir_wend if'#### MONTHLY BACKUP ####if Day(Now()) = 1 then oFS.CopyFolder timedir, backup_dir_mend if'########################Set oFS = Nothing' PadZero - add 0 if value min 10Function PadZero(val) If (val < 10) Then PadZero = "0" & val Else PadZero = val End IfEnd Function
No comments:
Post a Comment