I have this code to get a list of results based on a RegEx search of Everything.
Code: Select all
Dim searchRegex As String
searchRegex = Activesheet.Range("A:A").Find("Everything RegEx").Offset(0, 1)
Shell "C:\Program Files\Everything\Everything.exe -s """ & searchRegex & """ -regex -sort ""Path"""
Is there a way to send these results back to VBA as a delimiter-separated list? I am trying to get a count and, if necessary, output the list to a range of cells.
I thought creating a filelist might be useful but:
- I'm hoping to avoid having to create a file just to read from it and then delete it
- I have not found a way to limit it to filenames only (no other properties)
- It seems to be limited to searching a particular folder, not all of the ones set up in Everything.