Advertisement
Guest User

Untitled

a guest
Oct 17th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. Sub Save()
  2. ' Save Macro
  3. Set wshShell = CreateObject("WScript.Shell")
  4. strUser = wshShell.ExpandEnvironmentStrings("%USERNAME%")
  5.  
  6. currentYear = DatePart("yyyy", Now)
  7. currentMonth = DatePart("m", Now)
  8. currentMonthLength = Len(currentMonth)
  9. If currentMonthLength = 1 Then
  10. currentMonth = "0" & currentMonth
  11. End If
  12. currentDay = DatePart("d", Now)
  13. currentDayLength = Len(currentDay)
  14. If currentDayLength = 1 Then
  15. currentDay = "0" & currentDay
  16. End If
  17. currentDate = currentYear & currentMonth & currentDay
  18.  
  19. currentHour = DatePart("h", Now)
  20. currentHourLength = Len(currentHour)
  21. If currentHourLength = 1 Then
  22. currentHour = "0" & currentHour
  23. End If
  24. currentMinute = DatePart("n", Now)
  25. currentMinuteLength = Len(currentMinute)
  26. If currentMinuteLength = 1 Then
  27. currentMinute = "0" & currentMinute
  28. End If
  29. currentSecond = DatePart("s", Now)
  30. currentSecondLength = Len(currentSecond)
  31. If currentSecondLength = 1 Then
  32. currentSecond = "0" & currentSecond
  33. End If
  34. currentTime = currentHour & currentMinute & currentSecond
  35.  
  36. ChDir "C:UsersdocenkocDesktop"
  37. Sheets("Upload").Select
  38. 'ActiveWorkbook.SaveAs Filename:= _
  39. '"C:UsersdocenkocDesktop" & Range("C2") & "_" & currentDate & "_" & currentTime & "_" & strUser, FileFormat:= _
  40. ' xlExcel8, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
  41. ' , CreateBackup:=False
  42.  
  43. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement