I have several similar modules in PERSONAL.XLS , have not worked in these in
a while and have a hard time figuring out which is the most recent (and
updated) one. In case of ordinary files I can look up €œDate Modified€œ in
Windows Explorer but, where I did find PERSONAL.XLS, I did not find separate
modules.

Is there any way to determine the last €œDate Modified€� of separate modules?
Thanks very much.

-Joni

Joni,

No. The only property that a module has that is readable is its name.

The solution is to put the modified date at the top of the module, updated
every time you edit something.

HTH,
Bernie
MS Excel MVP


"jonigr" wrote in message
...
I have several similar modules in PERSONAL.XLS , have not worked in these
in
a while and have a hard time figuring out which is the most recent (and
updated) one. In case of ordinary files I can look up "Date Modified" in
Windows Explorer but, where I did find PERSONAL.XLS, I did not find
separate
modules.

Is there any way to determine the last "Date Modified" of separate
modules?
Thanks very much.

-Joni

Bernie, that's unfortunate, but thanks for letting me know.

-Joni

"Bernie Deitrick" wrote:

Joni,

No. The only property that a module has that is readable is its name.

The solution is to put the modified date at the top of the module, updated
every time you edit something.

HTH,
Bernie
MS Excel MVP


"jonigr" wrote in message
...
I have several similar modules in PERSONAL.XLS , have not worked in these
in
a while and have a hard time figuring out which is the most recent (and
updated) one. In case of ordinary files I can look up "Date Modified" in
Windows Explorer but, where I did find PERSONAL.XLS, I did not find
separate
modules.

Is there any way to determine the last "Date Modified" of separate
modules?
Thanks very much.

-Joni