asked on

In windows explorer (if possible) display files in a single folder in order of a match score

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

Thanks,
Kelvin

SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Rob Henson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Roger

ASKER

Rob: yes! I was just working on putting the copy files with concatenated file names into a temporary folder when your comment came in (as very welcome encouragement). Then I'd point Windows explorer at the temporary folder:

Dim temp_folder As String
temp_folder = "C:\winExpl_Tgt"
Call Shell("explorer.exe " & temp_folder, vbNormalFocus)

source: https://www.experts-exchange.com/questions/27763233/Open-a-File-Explorer-Window-using-VBA.html

Thanks

Roger

ASKER

Thank you for speedy support
Kelvin