Link to home
Start Free TrialLog in
Avatar of Flora Edwards
Flora EdwardsFlag for Sweden

asked on

List folders and sub-folders of a path with its size

i have seen couple of codes on the net for listing files from folders and sub folders, which does not really help me.

what i need is a VBA to run from Excel

prompts me to select a folder then once select it lists all folders and sub-folders from this path showing the followings information
Folder name,  Folder path , Folder Date created, Folder Size in Mega bites


thanks.
Avatar of Bill Prew
Bill Prew

Where do you want the "list" to be placed - in a text file, in an Excel sheet, etc?

No files are to be listed, just folders, correct?

~bp
Avatar of Flora Edwards

ASKER

thanks Bill.

Yes,  files to be shown in Excel

No files,  just folders and its sub-folders
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
many thanks Bill.

it worked.