| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to know the accessed date&time
Is it possible to know if an excel file on the network been openned but
without modified? I know I can find out the modified date and created date from windows explorer but I would like to know if my file has been read. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to know the accessed date&time
Try this ...
================================================= Public Function ModDate() ModDate = Format(FileDateTime("C:\Filename.xls"), "m/d/yy h:n ampm") End Function ================================================= replace file name with your file. *** Please do rate *** "Shuang Yu" wrote: Is it possible to know if an excel file on the network been openned but without modified? I know I can find out the modified date and created date from windows explorer but I would like to know if my file has been read. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File cannot be accessed | Excel Discussion (Misc queries) | |||
| How do I count how many times an Excel workbook has been accessed | Excel Discussion (Misc queries) | |||
| Can't open Excel workbook. Marked " cannot be accessed. | Excel Discussion (Misc queries) | |||
| Return to the last accessed cell in a multiple paged file at reent | Excel Discussion (Misc queries) | |||
| How do I format dates accessed by a formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
