+ Reply to Thread
Results 1 to 5 of 5

List files from a folder including data from columns displayed

  1. #1
    Registered User
    Join Date
    02-09-2017
    Location
    UK
    MS-Off Ver
    2019
    Posts
    59

    List files from a folder including data from columns displayed

    Hi

    Is it possible to list all files in a folder but also include the data from the columns which are currently in use on the folder?(I have been able to find how to get the basic information (File name, date created, file size etc) but I ma unable to work out how to get the information I would like (year, frame width).

    Thanks in advance

    CJW

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: List files from a folder including data from columns displayed

    Hello CJW,

    This works and can be expanded if needed.

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 07-20-2019 at 08:10 PM.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    02-09-2017
    Location
    UK
    MS-Off Ver
    2019
    Posts
    59

    Re: List files from a folder including data from columns displayed

    Thank you, does exactly what i needed ( i had no idea there were so many indices!)

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: List files from a folder including data from columns displayed

    Hello CJW,

    Thanks for the feedback. As a bonus, here is a macro that will list the indices names and numbers. This uses the ActiveSheet. So, add a blank sheet to your workbook and run the macro using the new sheet.

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 07-21-2019 at 05:27 PM.

  5. #5
    Registered User
    Join Date
    02-09-2017
    Location
    UK
    MS-Off Ver
    2019
    Posts
    59

    Re: List files from a folder including data from columns displayed

    thank you for the extra code.

+ 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] Trouble Updating a list of Files if a file no longer exists in the Folder/Sub Folder Dir.
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-26-2019, 02:03 AM
  2. Get List of files name and path from a folder including all sub folders
    By bennyys in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2017, 10:57 AM
  3. listing excel files in a folder including subfolders
    By olivermdantes in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-22-2016, 04:17 AM
  4. [SOLVED] Combining multiple files to workbook from folder, including subfolders
    By Punssiliini in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2015, 02:38 PM
  5. Replies: 11
    Last Post: 10-30-2013, 05:04 AM
  6. Adapt macro to create list of all PDF files in folder, including subfolders.
    By Glensafro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2013, 06:33 AM
  7. Counting files in folder including subfolders also and folder size
    By mido609 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2012, 03:26 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