+ Reply to Thread
Results 1 to 3 of 3

List all files in Directory and Subdirectory with File Property Details

  1. #1
    Registered User
    Join Date
    08-18-2016
    Location
    Earth
    MS-Off Ver
    2010 and 2013
    Posts
    64

    List all files in Directory and Subdirectory with File Property Details

    Hello,

    Is there a way to load and list all files in a directory and subdirectories with the file name AND file property origin detials (author, last editted, last saved by, etc)?
    Some values in the origin details might be blank, and in those cases for that field list it as a blank or FALSE or some other unique identifier.

    I have found code from http://software-solutions-online.com...ubdirectories/ that lists all files in the folder and sub folders, but it does not import the details. Screenshot shows the portion of the file property details I would like to import along with the file paths.

    Please Login or Register  to view this content.
    origindetails.PNG

    I hope my request makes sense. Data to show across multiple columns will be ideal, but if will load info in single cell, as long as there is some type of delimiter between each field.

    Thank you in advance and please let me know if you would like me to clarify anything.
    Last edited by Green Crocodile; 08-26-2016 at 03:24 PM. Reason: Added VBA code from SSO

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: List all files in Directory and Subdirectory with File Property Details

    snb lists ways to use GetDetailsOf(). http://www.snb-vba.eu/VBA_Bestanden_en.html

  3. #3
    Registered User
    Join Date
    08-18-2016
    Location
    Earth
    MS-Off Ver
    2010 and 2013
    Posts
    64

    Re: List all files in Directory and Subdirectory with File Property Details

    Awesome! It is a very extensive list too. Added to my bookmarks.

    Thank you
    01001000 01101001 00100001

+ 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. list subfolders and files of main folder with details
    By buerere in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2014, 10:44 AM
  2. Replies: 0
    Last Post: 03-13-2013, 09:08 PM
  3. Sorting list of files in a directory using the File System Object (FSO)
    By gincemathew in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2013, 01:50 PM
  4. Excel File Directory - List NEW Files only
    By lilanngel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2013, 03:54 PM
  5. List all files in directory in an Excel file
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-03-2009, 11:58 AM
  6. [SOLVED] List Files in a Directory
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2005, 08:15 PM
  7. Return most recent file in subdirectory with out using FileSearch
    By Enohp Aikon in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 10-03-2005, 07:05 PM

Tags for this Thread

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