Hi all,
Long time haven't been here :-) , asking for an advice / solution from someone who can help / spare some time:
(I am in Records Management field/profession, TRIM, Content Manager etc.)

OK, I have made a huge Home Family Archive "Console" in a form of VBA set of Forms.... It is a basically the colorful VBA FORM, with lots of buttons/menus etc. where i listed (mentioned) hard drives / file cabinets locations with all family videos, photos, documents, emails, soccer club's matches, photos games etc, then hard copy files, locations / storage list etc.
Obviously, these documents are stored on a multiple 8 TB hard drives and each hard drive can have up to 100,000 items and the Windows Search is just too slow, so i want to add to this VBA Console some sort of the instant search/ index of all these files/documents on all Hard Drives, that will point me instantly to a "clickable" location of the particular file.

So, something like a text field and a button "SEARCH" ... so when i type in the word e.g. "Sydney United" , then the search results should look like similar to this:
- Documents found:
- Sydney United vs Perth Glory soccer match 12 Sep 2002, MP4 video, location: Hard Drive K:\"Soccer Archives\years\2002\games\Sydney United\Sydney Vs Pert 12 sep 2010.mp4 .. click here to go to the file location.

I Understand that i first need all these "folder paths" extracted (using DOS) from each hard drive as a huge *.txt file (all drives combined) in order to create VBA script for search, but I do not know what would be the best solution how to create that;
- Whether the VBA Script search that index/txt file on each hard drive or
- The text file (document's folder paths are copied into the Excel sheet(s)
- Where the search results will be presented and whether they will be "clickable links?
- Also, if the search return many matches, how to display them....

- Or any other similar solution that someone can suggest would be much appreciated....

So, how would you be doing this?