Get the value of the last modification of an excell or word file

  • Hi everybody,

    I would like to get the date of the last modification of a word and an excell file. Besides, I wouldlike the same things for an access form, I mean, when the user modify datas dispplayed in an Access form, I would like to get the date.

    Thank U .

  • You'll need VBA to retrieve the date/time for the Excel or Word files, and I'm not very good with that...

    But in Access, you can simply make an additional field in your table for DataChangeDate, and make the default value be =NOW()

    You don't have to display that field on your form either...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!