A log of when an Excel document has been opened

FloydPalmer

New Member
Joined
Aug 30, 2016
Messages
43
Hi,

I have a document of someone else's that I check daily and it was made aware to me that the individual whose document it is, knew that I was doing this. And I wasn't sure how this was possible. As far as I know, there's no way to log when an Excel or Microsoft document has been opened (modified, yes - which I never did) so was it guesswork or making assumptions?

I thought perhaps the individual would have this document open all the time, and when I tried to open it, she'd get an alert (she was specific about how many times I was opening the document in a day)? I never had an alert saying "so and so has this document open would you like a read-only version?"

Baffled, any information helpful.

Thank you
 

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
789
Office Version
2007
Platform
Windows
If its a macro enabled document, then its easy to create a workbook open event handler which could be written to capture the date and time on a hidden sheet, send an email, etc. Also, there is a property of all windows files called 'accessed', which is set regardless of whether any changes are made.
 

FloydPalmer

New Member
Joined
Aug 30, 2016
Messages
43
If its a macro enabled document, then its easy to create a workbook open event handler which could be written to capture the date and time on a hidden sheet, send an email, etc. Also, there is a property of all windows files called 'accessed', which is set regardless of whether any changes are made.
To answer your former question, it's not (I would't know how to) but a simple Excel document. And on the latter, how could I access this?
 

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
789
Office Version
2007
Platform
Windows
Hi there. What version of excel is the file? To see the properties of any file, use File Explorer. Right-click on the file name and select Properties. The last time it was accessed (by anybody) is shown in the General tab. However, if as you say she knew when you had been accessing it, then I think its more likely she has a macro that runs when you open it. To check this, open the document and right-click on any of the tabs. Select View Code. This opens the VBA editor. Click on the ThisWorkbook shown in the left hand pane. Click Edit, Find and select Current Project. Then search for AutoOpen.
 

FloydPalmer

New Member
Joined
Aug 30, 2016
Messages
43
Hi there. What version of excel is the file? To see the properties of any file, use File Explorer. Right-click on the file name and select Properties. The last time it was accessed (by anybody) is shown in the General tab. However, if as you say she knew when you had been accessing it, then I think its more likely she has a macro that runs when you open it. To check this, open the document and right-click on any of the tabs. Select View Code. This opens the VBA editor. Click on the ThisWorkbook shown in the left hand pane. Click Edit, Find and select Current Project. Then search for AutoOpen.
It's Excel 2016.

I've tried the General tab by the route you've said on documents of mine, yet it gives the previous time I opened and accessed it. I would expect Accessed date/time to be different from Modified?
 

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
789
Office Version
2007
Platform
Windows
OK. You're right, I've just done a bit of digging and the accessed property is defaulted to the same as the updated property in Windows. The reason it works on my machine is we have a company policy that has this turned on (for backup utilities to work properly). So in your case, I don't think she's getting the info from windows. This brings me back to there being some macro code - what is the document suffix .xlsx, .xls or .xlsm?
 

FloydPalmer

New Member
Joined
Aug 30, 2016
Messages
43
OK. You're right, I've just done a bit of digging and the accessed property is defaulted to the same as the updated property in Windows. The reason it works on my machine is we have a company policy that has this turned on (for backup utilities to work properly). So in your case, I don't think she's getting the info from windows. This brings me back to there being some macro code - what is the document suffix .xlsx, .xls or .xlsm?
It's .xslx

If she has gone down the macro route, she's exceeded everyone's expectations!

Thank you for your help.
 

Forum statistics

Threads
1,081,983
Messages
5,362,551
Members
400,679
Latest member
alecalec202

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top