who last opened a file

  • Thread starter Thread starter Billy
  • Start date Start date
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
 
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
 
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)
 
Back
Top