Private Sub Workbook_AfterSave(ByVal Success As Boolean) Dim saveDate As Date Dim saveTime As Variant Dim formatTime As String Dim formatDate As String Dim backupFolder As String saveDate = Date saveTime = Time formatTime = Format(saveTime, "hh.MM.ss") formatDate = Format(saveDate, "DD MMM YYYY") Application.DisplayAlerts = False backupFolder = ThisWorkbook.Path & "\" ActiveWorkbook.SaveCopyAs Filename:=backupFolder & Replace("Backup-" & ActiveWorkbook.Name, ".xlsb", "") & " " & formatDate & " " & formatTime & ".xlsb" Application.DisplayAlerts = True ' MsgBox "Backup Successfully In The Path " & backupFolder End Sub
Jumat, 03 Desember 2021
Backup File
Langganan:
Posting Komentar (Atom)
Menghitung USIA Excel
=BYROW(D2:D100; LAMBDA(tanggal_lahir; IF(tanggal_lahir=""; ""; DATEDIF(tanggal_lahir; TODAY(); "y"...
-
Salin ke Clipboard Salin ke Clipboard Salin Tercopy! ...
-
=MOD(ROW();2)=1
-
Option Explicit Private Sub Workbook_BeforeClose(Cancel As Boolean) Select Case MsgBox("Apakah anda ingin menyimpan file ini?", v...
Tidak ada komentar:
Posting Komentar