How would I embed Everything in Excel VBA

[j2associates]

I have this scenario:
a. There is a Reports folder with thousands of files in it
b. I need to scan the Reports folder to match a user selection using a regular expression (e.g. Sales*Inv*)
There might be Sales Invoice, Sales - Invoice, Sales Inv Archive, etc.
c. Then I need to iterate the result set and do further processing

So basically, I think I need to emulate a command line with RegEx enabled, something like the following:
ReportsFolder regex:UserSelection

1. Am I on the right track
2. How do I ensure RegEx is enabled and enable it if it is not
3. How do I find and iterate the result set

Thanks in advance for any help and/or suggestions!

[froggie]

Excel VBA supports both Regex and reading directories. Plenty of examples online. As much as I love Everything, It might be simplier & easier to just stay within Excel

[NotNull]

Where is the relation with Excel VBA?

I think we need more (real-life) details to give you an answer.

BTW: Sales*Inv* is not a correct regular expresssion. Technically it is, but it will not find the files/foders you are looking for.

[void]

Please find an Everything SDK Visual Basic example here:
Everything.SDK.Visual.Basic.Example.zip

Please try wildcards instead of Regex.
Wildcards are enabled by default.

[j2associates]

You are correct, that was not a correct regex. Sorry, got in too much of a hurry.

I downloaded the zip file, but it is looking for an Everything32.dll which is not included in the zip file.

[void]

You willl find the Everything32.dll in the Everything SDK.

https://www.voidtools.com/support/everything/sdk/