Add LastFileDate update date in cell

		Microsoft Office Forums > Microsoft Excel > Excel
Add LastFileDate update date in cell

05-25-2025, 07:57 AM

Alansidman Alansidman is offline

Windows 11 Add LastFileDate update date in cell

Office 2021

עַם יִשְׂרָאֵל חַי

Join Date: Apr 2019

Location: Steamboat Springs

Posts: 121

Will the last saved date and time work for you?

If yes, then

Code:

Sub LastSaved()
    Dim x As Date
    x = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
    MsgBox (x)
End Sub

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2511

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do i highlight a cell red if no date has been entered 30 days after a date in another cell??	Daronovitz	Excel Programming	10	07-29-2022 10:32 AM
Formula for looking at 1 cell with a date and then comparing it to four date ranges	LearningMom	Excel	3	10-27-2017 12:44 PM
calculate date if date entered in cell, do nothing if blank	ConfuddledOne	Excel	3	11-07-2014 09:37 AM
Make table cell active add date count date	MelHerndon	Word VBA	3	01-21-2013 04:23 PM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:59 PM.