How to know the accessed date&time

S

Shuang Yu

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
 
N

Naveen

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 ***
 
Top