View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default how to log all excel files opened on my pc?

A place to start would Application level events:
http://www.cpearson.com/excel/AppEvent.htm

Then each time a WB is opened, log the .Name/.Path to somewhere suitable.

NickHk

wrote in message
oups.com...
I'm looking for a program or process by which all excel files will be
written to a text log file or a personal.xls worksheet on my pc.

A log entry would be created each time I open a file.

The log entry would list the name of the file, the path, the date, and
time, and the file type.

Any ideas would be much appreciated.

Thanks,

JGalt