+ Reply to Thread
Results 1 to 2 of 2

Macro to list all files and folders in sub folders and choose a starting folder

  1. #1
    Registered User
    Join Date
    01-08-2014
    Location
    Bath, UK
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    86

    Macro to list all files and folders in sub folders and choose a starting folder

    Hi,

    I'm trying to get a list of all the files and folders (with the path name) and the date the file was last amended, please?

    I've found the enclosed code which gives a list of the files with the path, but I wonder is it possible to dictate a particular starting location, rather than just starting at "Desktop"? Although I can sometimes copy, paste and amend bits of VBA to achieve what I need, I can't "see" how to do it in this..?

    I'd also like to see the date the file was last amended, please - we use several files each day, so this serves as one of the checks to check whether the files have been updated. I'd prefer the date to be listed in a separate column - e.g. file name and path in column A, date in column B. If it's possible to split the folder into one column and the filename (with extension) in a separate column, that would be perfect!

    Can anyone help, please?

    Thanks,
    Graham


    Please Login or Register  to view this content.
    Last edited by LeanAccountant; 05-06-2021 at 11:54 AM.

  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: Macro to list all files and folders in sub folders and choose a starting folder

    Change c:\myfiles\pdf to your path.
    Please Login or Register  to view this content.
    Last edited by Kenneth Hobson; 05-06-2021 at 02:08 PM.

+ 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. Replies: 5
    Last Post: 11-02-2018, 03:15 AM
  2. [SOLVED] List files of folder and sub folders without Loop
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 10-17-2018, 02:18 AM
  3. 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
  4. [SOLVED] macro to list files in folder and sub folders has stopped working
    By Lmel0611 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2015, 09:12 PM
  5. Replies: 0
    Last Post: 05-26-2014, 07:47 PM
  6. Replies: 1
    Last Post: 09-12-2013, 09:23 PM
  7. Replies: 0
    Last Post: 07-13-2012, 10:51 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