Excel last modified date
 

mike,

Last Modified is irrelevant.
You can modify a file all you want but until you save it (with
whatever "modifications" you make), there isn't a "Last Modified"
Date and time.

What might work for you is the following:
activeworkbook.builtindocumentproperties ("last save time")
Which will give you the last date and time that the file was
actually saved. It won't tell you though if any changes have
been made when it was saved though.

John

mike wrote:

I know how to get the files last modified date for the
active excel file. My problem is when I put the code in
the Auto_open macro, every time it opens and runs it
changes the date. Does the Auto open macro modify the
file?? What else could I do to get it to check this date
automatically for me??

Excel last modified date
 

Thanks john
-----Original Message-----
mike,

Last Modified is irrelevant.
You can modify a file all you want but until you save it
(with
whatever "modifications" you make), there isn't a "Last
Modified"
Date and time.

What might work for you is the following:
activeworkbook.builtindocumentproperties ("last save
time")
Which will give you the last date and time that the file
was
actually saved. It won't tell you though if any changes
have
been made when it was saved though.

John

mike wrote:

I know how to get the files last modified date for the
active excel file. My problem is when I put the code in
the Auto_open macro, every time it opens and runs it
changes the date. Does the Auto open macro modify the
file?? What else could I do to get it to check this
date
automatically for me??

.