Chuck

I think it will be rather difficult to get to the text string that
shows up when you use Notepad to be viewable in an Excel file. It
would be easy to write the name of the user who opens a file into a
text file whenever a file is opened. The reading of that text file
would be easy. If you are interested in that approach, you should
repost, as I am sure there are plenty on instances of code available
to write to text files to track activity in a spreadsheet.

Ken

On Jan 4, 9:36*am, CLR wrote:
Hi All...........

John Walkenbach has an article on his site that describes how to use WordPad
to see who was the last person to open a particular .xls file.......it's here

http://j-walk.com/ss/excel/odd/odd26.htm

My question is, *how to use VBA to *interrogate a *.xls file and extract
this information? *

TIA
Vaya con Dios,
Chuck, CABGx3