Getting timestamp from a file in Excel
 

Hi,

I'm looking for a macro/function that will allow me to get the
timestamps properties (date created) for a file in Excel and paste this
into a particular cell.

I imagined the set up would be something like:

Cell A1 - File location
Cell B1 - File name
Cell C1 - =Today()
Cell D1 - Some formula/macro/function that says "If the datestamp of
A1&B1 is the same as C1 then put a tick"

Can anyone help?

Many Thanks
Patrick

You can get the creation date in VBA via:

activeworkbook.BuiltinDocumentProperties("creation date")

"Patrick" wrote:

Hi,

I'm looking for a macro/function that will allow me to get the
timestamps properties (date created) for a file in Excel and paste this
into a particular cell.

I imagined the set up would be something like:

Cell A1 - File location
Cell B1 - File name
Cell C1 - =Today()
Cell D1 - Some formula/macro/function that says "If the datestamp of
A1&B1 is the same as C1 then put a tick"

Can anyone help?

Many Thanks
Patrick