Can I know if my file was opened yesterday?

  • Thread starter Thread starter joker197cinque
  • Start date Start date
J

joker197cinque

Yesterday I forgot a word document on my desktop and after a while I
had to leave my pc to a colleague.

Today I first opened this document and now I would like to know if
yesterday was also opened.

Is it possible?

Regards.
 
Hi,

My knowledge of Word is limited in the extreme but my answer would be yes.

Open your document
Alt+F11 to open vb editor
Doubleclick ThisDocument
Paste this in on the right

Private Sub Document_Open()
Open "c:\docs_opened.txt" For Append As #1
Print #1, ActiveDocument.Name & " " & Date & " " & Time & " " &
Application.UserName
Close #1
End Sub

On opening it wil write the document name, date and time opened and the
username to a file called docs_opened,txt in the root of C.

Mike
 
While that might work for the future, I don't see how this will help
determine whether the document was opened yesterday? Word doesn't store this
data. There is no way of determining from the document who has already
viewed it and when.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top