View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default how to log all excel files opened on my pc?

Hi

Try this.

Sub Auto_Open
Open "C:\usage.log" For Append As #1
Print #1, Thisworkbook.Name, Thisworkbook.Path, Now
Close #1
End Sub

Bob

" wrote:

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