In excel ws column A there is a list of file names from a SINGLE known folder.
In col B, there is a single numerical match score, for the match of the text contents of each file to a set of search terms.
Working in vba, I want to display the files in Windows Explorer (for preference) in match score order, and preferably display match scores against file names in the Explorer search report window.
If not Windows explorer, then an application that can be called from an excel vba function.
If possible I'd like 'click-selected' files in the output list of matching files to be previewed in a thumbnail pane (as in windows explorer)
- windows 7 OS
If there is a solution that includes searching and matching functions, then that could be ideal.
Text file size <500 characters exl spaces
Search terms (words/phrases) upto 10