who last opened a file

B

Billy

I read on someones site that you can open notepad file and it will
show who last used a particular excel file. can anyone telll me how
its done, or where to find that article?
thanks,
tonso
 
C

CLR

File > Properties > StatisticsTAB will show who last SAVED the
file........and when it was last accessed...............don't know how to
tell who last just opened it without saving..........

Vaya con Dios,
Chuck, CABGx3
 
C

Chip Pearson

If you are referring to files in the 2007 file format (*not* 2003 and
earlier format), you can look at the XML files that make up the Excel file.
Excel 2007 files are really Zip (compressed) files which contain a number of
XML files as plain text (a concept that should have security and audit folks
quite alarmed).

Using your favorite Zip program (e.g., WinZip, PKZip, SecureZip), unzip the
XLSM or XLSX file. You'll get a number of files and folders. In the docProps
folder, open the Core.xml file in Notepad or your favorite XML Editor (I use
XML Spy from Altova). There, search for the string

<dc:creator>

This element contains the user who last used the file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 

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

Similar Threads

Who last opened file? 5
Modified File By User 1
Where are the Properties.Settings.Default stored on disk? 4
Downgrading from Windows 11 1
Open a corrupted File??? 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Determine Full Path of an Opened XL File 4
Determine who last modified an Excel file???? 5

Top