Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by nigelpull
-
Display last saved date in cell in Excel
It worked! I am trying to keep a list of various issues together in a list. This list is changed often and by different individuals. I was hoping to create a SS with a cell at the top that will always display the last time the file was saved, to save some confusion. Is there a way to invoke a...- nigelpull
- Post #7
- Forum: Microsoft: Office
-
Display last saved date in cell in Excel
That response was better than a book. Custom made for me! Thank you for your time and patience.- nigelpull
- Post #6
- Forum: Microsoft: Office
-
Display last saved date in cell in Excel
I still need help where do I enter: Sub Get_SaveData() curfile = Application.ActiveWorkbook.Name SaveData = FileDateTime(curfile) ActiveCell.Value = SaveData End Sub How do I reference it in a cell? Does it update automatically? Can you send me an example, please? I have never used...- nigelpull
- Post #3
- Forum: Microsoft: Office
-
Display last saved date in cell in Excel
How do I show, in a cell, the last date and time that the excel file was saved? The "now" function only shows the time and date that the file was opened, not saved. If VBA is needed please be very descriptive since I have never used it before.- nigelpull
- Thread
- Replies: 19
- Forum: Microsoft: Office
