I am trying to create a macro in excel to give me a listing of all the files in a folder (including subfolders).

The information I would need from it would be:
Filename (including extension)
Path (including filename and extension)
File Size
Length of filename (and extension)
Length of path (including filename and extension).

Ideally I would browse for the root folder, or maybe paste the path following a prompt?

Can anyone help me out?

Thanks,
Laneyboggs