I have a favorites add-in that I use every day. There’s always a couple of frequently used files that I can’t add to my favorites menu because they change periodically.
One example is my inventory reconciliation file. I have several such files in a folder and they are named InvRecon20081130.xls and InvRecon20081231.xls. I need my favorites menu to adjust to give me the file I need.
I can add and delete these files from my menu every month, but I’d prefer to just have the menu update it as necessary. I took a crack at designing an interface to set up a dynamic favorite.
In January of 2009, I always want to point to my 12/31 reconciliation
Or maybe I always want the 15th of the current month
Two other considerations: Maybe I want the 15th of the current month, only if it’s later than the 20th. If it’s earlier than the 20th, maybe I want the 15th of the previous month. Maybe that’s going to far.
Also, I have some files that aren’t updated periodically, but haphazardly. In some cases, I want the file name with the latest date in the folder. I haven’t coded those two scenarios, but I’m thinking about them.
Do you have some dynamic filenames that you’d like to have on a favorites menu that this won’t handle? What do you think of the interface? Is it intuitive enough? If you download it, you’ll notice that I have an example in the Enter textbox when the form is opened; helpful or confusing?
Download DynamicFavorite.zip if you want to mess around with it.