+ Reply to Thread
Results 1 to 6 of 6

Extract a list of subfolders with file count and size for each subfolder

  1. #1
    Registered User
    Join Date
    06-16-2014
    Posts
    16

    Extract a list of subfolders with file count and size for each subfolder

    Hi, the code below extracts a list of subfolders with their path, dir, name, created and modified dates. It works well

    I would like to add two columns to the output - a file count for each subfolder and the total size of the subfolder

    Thanks in advance

    Cheers, Luigi

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Extract a list of subfolders with file count and size for each subfolder

    Try this updated version

    Please Login or Register  to view this content.

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Extract a list of subfolders with file count and size for each subfolder

    Hi,

    I´m no great fan of On Error Resume Next, maybe change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    and see if it works as expected.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Registered User
    Join Date
    06-16-2014
    Posts
    16

    Re: Extract a list of subfolders with file count and size for each subfolder

    Bellissimo. Molto Gracie!

  5. #5
    Registered User
    Join Date
    06-16-2014
    Posts
    16

    Re: Extract a list of subfolders with file count and size for each subfolder

    Thanks, this worked well also

  6. #6
    Registered User
    Join Date
    06-16-2014
    Posts
    16

    Re: Extract a list of subfolders with file count and size for each subfolder

    Cheers, took a while but produced the result on a very big folder

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count and copy subfolders and modify a TXT file
    By Andrew Entee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2017, 02:18 PM
  2. Replies: 14
    Last Post: 09-18-2016, 08:13 AM
  3. Replies: 0
    Last Post: 09-18-2015, 03:20 AM
  4. [SOLVED] Macro to list subfolders only, no file
    By JJGF in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2014, 12:54 PM
  5. Macro to rename photos in a main folder's subfolders to subfolder names
    By Spardante in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2014, 11:41 PM
  6. Merge one sheet from several workbooks in subfolders excluding one subfolder
    By ExcelMacrome in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-23-2012, 07:37 PM
  7. [SOLVED] Creating folders and subfolders from excel file list
    By afaubert in forum Excel General
    Replies: 4
    Last Post: 11-08-2005, 07:50 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1