reza_akbar
New member
Code:
Sub SaveIt()
Dim dt As String, wbNam As String
wbNam = "Log book"
dt = Format(CStr(Now), "yyyy_mm_dd_hh_mm")
ActiveWorkbook.SaveAs Filename:=wbNam & dt
End Sub
how to make save in set path, like D:\file magang\hasil magang vba