ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   last €śDate Modified€ť of separate modules? (https://www.excelbanter.com/excel-programming/396057-last-%E2%80%9Cdate-modified%E2%80%9D-separate-modules.html)

jonigr

last €śDate Modified€ť of separate modules?
 
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 Deitrick

last "Date Modified" of separate modules?
 
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




jonigr

last "Date Modified" of separate modules?
 
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






All times are GMT +1. The time now is 07:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com