Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2008

Tip: Looking for answers? Try searching our database.

who last opened a file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Billy - 03 Jan 2008 18:39 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.