+ Reply to Thread
Results 1 to 4 of 4

VBA code to get list of files from multiple paths

  1. #1
    Registered User
    Join Date
    02-26-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    33

    VBA code to get list of files from multiple paths

    Hi All,

    I am trying to get the list of files and the created date from multiple paths.

    There are around 65 paths. All the paths will be listed in sheet1. The Macro has to check all these paths and update the required details in the sheet2.

    Can you please help me with a sample for this.

    Thanks in advance!

  2. #2
    Forum Contributor
    Join Date
    12-24-2014
    Location
    little ole England
    MS-Off Ver
    2013
    Posts
    116

    Re: VBA code to get list of files from multiple paths

    have a look at this ..

    see if it helps the code is unprotected so you can edit for your exact needs

    hope it helps
    Attached Files Attached Files
    ◄Ŧя?μвŁ?►
    By Name & By Nature

  3. #3
    Registered User
    Join Date
    02-26-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: VBA code to get list of files from multiple paths

    Hi,

    Thanks for replying. But this macro gets the list of files only from 1 path. I have multiple path. Around 65 paths.

  4. #4
    Forum Contributor
    Join Date
    12-24-2014
    Location
    little ole England
    MS-Off Ver
    2013
    Posts
    116

    Re: VBA code to get list of files from multiple paths

    it will get all subfolders in the path too

    so if all folders are in same parent folder it will pull all files below

+ 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. Name definitions as files or paths
    By fitzt70 in forum Excel General
    Replies: 1
    Last Post: 11-28-2013, 07:17 PM
  2. Rename files and store them at different paths.
    By Hjahren in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-19-2010, 09:31 AM
  3. Identify identical files names w/ different url paths
    By sc0tt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2008, 10:18 AM
  4. Replies: 0
    Last Post: 04-21-2005, 06:40 PM
  5. Looking for files with UNC paths
    By CQMMAN in forum Excel General
    Replies: 1
    Last Post: 01-13-2005, 08:06 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