J
Joseph Lam
I'm trying to automatically format my report footers with
certain information, one of the items being the last date
of modification or save date. This is done on the fly
using the workbookbeforeprint event. The only problem is
that after opening a file the lastmodified date becomes
the current date until you close the file without saving,
at which time it reverts back to the true value. Is there
a place where the true lastmodified date is kept while the
file is open? If not, is there a workaround other than
copying the file upon opening and querying the copy which
is closed?
Thanks!
certain information, one of the items being the last date
of modification or save date. This is done on the fly
using the workbookbeforeprint event. The only problem is
that after opening a file the lastmodified date becomes
the current date until you close the file without saving,
at which time it reverts back to the true value. Is there
a place where the true lastmodified date is kept while the
file is open? If not, is there a workaround other than
copying the file upon opening and querying the copy which
is closed?
Thanks!