Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2021, 11:34 AM
Alaska1 Alaska1 is offline Last Updated field Windows 7 64bit Last Updated field Office 2007
Advanced Beginner
Last Updated field
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default Last Updated field

I need to put a last updated field in my excel document. Is there a function that will display the last date the file was updated?
Reply With Quote
  #2  
Old 09-07-2021, 03:59 PM
Logit Logit is offline Last Updated field Windows 10 Last Updated field Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Untested here :

Displaying Last Modification Time in Excel - RowShare
Reply With Quote
  #3  
Old 09-07-2021, 06:42 PM
Alaska1 Alaska1 is offline Last Updated field Windows 7 64bit Last Updated field Office 2007
Advanced Beginner
Last Updated field
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default

Thank you for the information.
Reply With Quote
  #4  
Old 09-07-2021, 07:52 PM
Logit Logit is offline Last Updated field Windows 10 Last Updated field Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Let me know how it works.
Reply With Quote
  #5  
Old 09-09-2021, 10:53 AM
Alaska1 Alaska1 is offline Last Updated field Windows 7 64bit Last Updated field Office 2007
Advanced Beginner
Last Updated field
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default

Thank you. The below worked.

Paste the following code into the new module:Public Function ModDate()ModDate = Format(FileDateTime(ThisWorkbook.FullName), “m/d/yy h:n ampm”)End Function
Before saving your module, make sure to save your Excel file as Excel Macro-Enabled Workbook
Save your module
Return to your Excel worksheet
Paste the following code into the cell where you want to display the last modification time: =ModDate()
Reply With Quote
  #6  
Old 09-09-2021, 01:15 PM
Logit Logit is offline Last Updated field Windows 10 Last Updated field Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Last Updated field LINK field path will be updated automatically bynkook Word 1 02-28-2020 02:54 AM
BCWP 0 with % Complete updated Melissa7 Project 0 04-17-2019 10:08 AM
Please tell me about updated custom wrappers Dick_in_Dallas Misc 0 03-18-2015 12:56 PM
Getting updated info from contacts ablackburn Outlook 0 01-02-2013 08:19 PM
Item Already updated simon@resultsoftware.co.u Outlook 0 07-25-2011 04:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft