I am getting too old to remember where I put things.

[farrissf]

I use Excel daily and it has become second nature to me. My problem is we have so many network drives and folders on my machine that I use, I cannot remember what I worked on. I often find myself being asked a question and remembering that I already solved that issue but I can't find it! Years ago I ran across a macro that listed every file that I had opened up going way back. Unfortunately, you guessed it... I cannot recall where I got it or what it was called. I know I paid for it but it was 10 years ago or more.

I am not very good at creating macros but here is what I am looking for, when I open an Excel spreadsheet or create an Excel Spreadsheet it would record the name of the sheet every time it is saved, the location of where it was saved, and the date the entry was made. Of course, I want this information to be on a spreadsheet that does not need to be opened in order to make an entry. I think it would be great if it had tags and a few other things that are appropriate. I think I am not the only one that could use something like this, does anyone have any ideas?

 

[Jaafar Tribak]

This is not difficult to do if you want to apply to excel files only... You can create a small addin (xlam extension) to catch the save events of each and every workbook and then simply transfer any info you want to some file (to a text file or to another excel workbook) in your disk.

Do a search for creating addins and for the WithEvents keyword for sinking the excel application events.