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.