Check Number of Files in Directory

I have a directory in a macro called 1Folder.

How can I check if 1Folder has 24 files in it, and if yes then proceed, but if not display a message box and stop the macro?

Thanks!
dvent

Hello dvent,

You can use the File System Object to return the files in a specified folder.

Please Login or Register  to view this content.

Macro Example
Change the folder path to the one you want to check.

Please Login or Register  to view this content.

Sincerely,
Leith Ross