Results 1 to 3 of 3

Thread: Article: Count Files (with a specific extension or not) in a folder and subfolders

  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,091
    Articles
    79
    Blog Entries
    14

    Article: Count Files (with a specific extension or not) in a folder and subfolders



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2
    Excelente código!
    Muchas gracias desde Perú.

    Code excelent!
    Thanks very much from Peru.

  3. #3
    Hello Ken,

    I'm somewhat of a Noob to this stuff so thanks for your patience. I implemented this code into one of my sheets. After I added it I put in one of the cells for example - =CountFiles_FolderAndSubFolders("W:\Yoyo\jenga\","*.*") It returns the total files in the folders and subfolders. When I change the last extension to "*.pdf" it comes back with 0 when I know there is 2 pdfs in the folders. Am I writing the function wrong in the cell?

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •