Solved

Editing excel file

Posted on 2011-09-29
2
185 Views
Last Modified: 2012-05-12
We have an excel file on a network drive that everyone can access.  Someone changed something on the file and we are trying to determine who that was.  Is there anyway to do this?
0
Comment
Question by:mkramer777
  • 2
2 Comments
 
LVL 19

Expert Comment

by:akoster
ID: 36815308
you could try opening it, adding a macro with this code and running it.
MsgBox ActiveWorkbook.BuiltinDocumentProperties("Last author")

Open in new window

0
 
LVL 19

Accepted Solution

by:
akoster earned 250 total points
ID: 36815344
same information can be retrieved without using macro by

- click on the round office button (excel 2007) ZA010077102.gif
- point to "Prepare"
- click "Prioperties"
- point to "Document Properties"
- click "Advanced properties"
- on the "statistics" tab you will find the 'last saved' by information
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now