What it does
Shows an auto-complete search form that can be used to find and open a recent file. 

When to use it
When you want to quickly open a file you’ve worked on recently just by entering part of the file name or file path, or you don’t remember exactly where you saved the file.

Why to use it
This macro shows search suggestions as you type, making it extremely quick to find files, especially when you don’t remember exactly where you saved the file.

Default shortcut
Ctrl+Shift+O

Other Details

• Category: Sheets / Files and Folders
• Difficulty: 2/5
• Usage/frequency: 3/5
• Automation factor: 3/5 (estimated 10 seconds saved each time used)
• Type: Shortcut
• Date added: 2/3/2019
• Tags: search, auto complete, files

Related Macros
None

Other Articles
None

None

Prerequisites
None

Instructions
Run the Search Recent Files macro.  It will prompt you with a search form offering you suggestions of recently used files as you type.  Use the up and down arrows (or click with the mouse) to select a suggested file and insert the entire file path in the search box.  When the entire file path is in the search box, press the Enter key to open the file.

Press the Escape key to clear the search box.  If the search box is empty when you press the Escape key, the search box will close.  You can also clear the search box by pressing the X icon to the right of the search box.

You can optionally select how many months of recent files to search through.  The default is 12 months.  If you change this value, it will be saved for future use.

There are three icons to the right of the search box that will sort the search results either ascending, descending, or in the order they were saved.  Records are updated in the list as they are saved with the date modified and file size.

To remove a saved record from the list, click the Remove record button.  To reset the list and remove all saved records from the list, click the Remove all records button.