Count Files in a folder and subfolders, with specific name

I found this code which counts files in a folder & subfolders, with a specific string in the filename.
I want to amend it so that it counts files with the same name as the active workbook.
Criteria is:
- Without specifying in the code what the active workbook name is.
- Disregard the extension. Example, active workbook "MyFile.xlsx" counts "MyFile.pdf".
- A full match is required, no wild cards.

Does anyone have any pointers?

Link.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi Excel_&_Help,


Try the following code:

Please Login or Register  to view this content.

It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

Lewis

Please Login or Register  to view this content.

@LJMetzger, @ranman256
Thanks very much, both of these modules work.
Just with the latter, it includes wildcards.