Count Files in a folder and subfolders, with specific name

[Un-Do Re-Do]

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.

[LJMetzger]

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

[ranman256]

Please Login or Register  to view this content.

[Un-Do Re-Do]

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

[bakerman2]

You don't need a seperate fuction to get activeworkbook name.

Please Login or Register  to view this content.