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
CLR - 03 Jan 2008 18:56 GMT
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
> 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
Chip Pearson - 03 Jan 2008 19:53 GMT
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.

Signature
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
>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
kaliman - 04 Jan 2008 13:57 GMT
Maybe this is what you saw
http://j-walk.com/ss/excel/odd/odd26.htm
Regards.
> 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