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
|