SOLVED

Displaying file saved date in a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1758315%22%20slang%3D%22en-US%22%3EDisplaying%20file%20saved%20date%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1758315%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20was%20looking%20for%20a%20function%20to%20display%20the%20file%20saved%20date%20in%20a%20cell.%3C%2FP%3E%3CP%3EI%20was%20able%20to%20find%20cell(%22filename%22)%20that%20displays%20the%20file%20name%20in%20a%20cell%20in%20a%20particular%20worksheet.%26nbsp%3B%20Would%20be%20nice%20to%20find%20a%20function%20similar%20to%20this%2C%20that%20can%20display%20the%20date%20the%20file%20was%20last%20saved.%26nbsp%3B%20If%20anyone%20knows%2C%20how%20to%2C%20drop%20me%20a%20note%20please.%26nbsp%3B%20I'm%20not%20a%20vba%20programmer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EKal%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1758315%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1758349%22%20slang%3D%22en-US%22%3ERe%3A%20Displaying%20file%20saved%20date%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1758349%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F824758%22%20target%3D%22_blank%22%3E%40kal_qg%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20does%20require%20VBA%20-%20see%20%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F3507-excel-last-saved-timestamp.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHow%20to%20insert%20last%20saved%20timestamp%20into%20worksheet%20cell%20in%20Excel%3F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1758446%22%20slang%3D%22en-US%22%3ERe%3A%20Displaying%20file%20saved%20date%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1758446%22%20slang%3D%22en-US%22%3E%3CP%3EThank%26nbsp%3Byou%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWorked%20great!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

I was looking for a function to display the file saved date in a cell.

I was able to find cell("filename") that displays the file name in a cell in a particular worksheet.  Would be nice to find a function similar to this, that can display the date the file was last saved.  If anyone knows, how to, drop me a note please.  I'm not a vba programmer.

 

Regards,

Kal

2 Replies
Highlighted
Best Response confirmed by kal_qg (New Contributor)
Highlighted

Thank you@Hans Vogelaar 

Worked great!