Advertisement
Guest User

Untitled

a guest
Apr 22nd, 2012
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. 'Run RRL macro at 6:30 AM
  2. Sub Run_At_630AM()
  3. Application.OnTime TimeValue("06:30:00"), "RRL"
  4. End Sub
  5.  
  6. 'Run TRL2 macro at 6:31 AM
  7. Sub Run_At_631AM()
  8. Application.OnTime TimeValue("06:31:00"), "TRL2"
  9. End Sub
  10.  
  11. 'Save entire workout as test.yyyymmddhhmmss.xls
  12. Sub SaveAs()
  13. ActiveWorkbook.SaveAs Filename:="C:\test " & _
  14. Format(Now(), "YYYYMMDDhhmmss") & ".xls"
  15. End Sub
  16.  
  17. 'Update Cell C2 with last Saved date and time
  18. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
  19. Sheets("RL").Range("c2").Value = last_saved()
  20. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement