#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Thank you for the information.
|
#4
|
|||
|
|||
Let me know how it works.
|
#5
|
|||
|
|||
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() |
#6
|
|||
|
|||
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |