Displaying the date a word document was updated in excel

[michaelhill94]

I don't know if this is possible but here goes. I have an excel file which is linked to a lot of word documents via dropbox. These documents are supposed to be updated by various people on a fairly regular basis and if they are not updated people may need reminding! Therefore I was wondering if there was any way I could display the date each file was last updated in an excel document? Thank you for any help. The office package is 2013.

[codeslizer]

Hey Michael,

I hope saving the time stamps of users editing it would help. Following function can be used to get the timestamp on both sheet as well as in VBA.

Please Login or Register  to view this content.

It would return the user name of the person logged into their computers and the time they update the file. Hope it helps!

[michaelhill94]

Thanks for the help, but I'm not really sure what to do with that function I'm quite bad at all this stuff! I've got the timestamp in the word documents but I'm not sure how to use that function to put that timestamp into the excel document.