Question: check how many files in folder vba?
Answer: Count txt files in Folder. Sub Demo() Call CountFilesInFolder("C:\Users\Ryan\Documents\", "*txt") End Sub.
Count Excel files in Folder. ... 
Count All Files in Folder. ... 
Only Count Files with "report" in the Filename.