How would I embed Everything in Excel VBA

General discussion related to "Everything".
Post Reply
j2associates
Posts: 13
Joined: Wed Feb 05, 2020 12:37 pm

How would I embed Everything in Excel VBA

Post by j2associates » Fri Feb 14, 2020 11:42 am

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
Posts: 147
Joined: Wed Jun 12, 2013 10:43 pm

Re: How would I embed Everything in Excel VBA

Post by froggie » Fri Feb 14, 2020 3:21 pm

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
Posts: 1875
Joined: Wed May 24, 2017 9:22 pm

Re: How would I embed Everything in Excel VBA

Post by NotNull » Sun Feb 16, 2020 4:27 pm

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
Site Admin
Posts: 5245
Joined: Fri Oct 16, 2009 11:31 pm

Re: How would I embed Everything in Excel VBA

Post by void » Mon Feb 17, 2020 11:23 pm

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
Posts: 13
Joined: Wed Feb 05, 2020 12:37 pm

Re: How would I embed Everything in Excel VBA

Post by j2associates » Fri Feb 21, 2020 3:40 pm

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
Site Admin
Posts: 5245
Joined: Fri Oct 16, 2009 11:31 pm

Re: How would I embed Everything in Excel VBA

Post by void » Sat Feb 22, 2020 7:40 am

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

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

Post Reply