Find filename, path, document size, filename length and path length?

**Laneyboggs** · 04-30-2010, 09:29 AM

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

**Leith Ross** · 04-30-2010, 08:01 PM

Hello Laneyboggs,

This macro lets you choose your starting folder and whether you want to list all the sub-folders. You can also choose the starting cell on the worksheet. If you don't supply a starting cell, the default is "A2" of the active worksheet. This macro works with Excel 2000 and later.

Please Login or Register  to view this content.

Example of Calling the Macro from VBA

Please Login or Register  to view this content.

Find filename, path, document size, filename length and path length?

LinkBack

Thread Tools

Rate This Thread

Display

Find filename, path, document size, filename length and path length?

re: Find filename, path, document size, filename length and path length?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions