bluefuel318
New Member
- Joined
- Feb 8, 2007
- Messages
- 30
Is there a way to find out when the last time you ran a macro was?
Sheet1.Range("A1").Value = DateTime.Now
Sub log()
Application.ScreenUpdating = False
Workbooks.OpenText Filename:="C:\Macro Run Dates.xls"
[a1].Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
ActiveCell = "Macro Name"
ActiveCell.Offset(0, 1).Select
ActiveCell = "=today()"
ActiveCell.Copy
ActiveCell.PasteSpecial xlPasteValues
Workbooks("Macro Run Dates.xls").Save
Workbooks("Macro Run Dates.xls").Close
Application.ScreenUpdating = True
End Sub