+ Reply to Thread
Results 1 to 5 of 5

Help Copy files from one folder and subfolders to another based on a list in Excel

  1. #1
    Registered User
    Join Date
    09-30-2019
    Location
    London
    MS-Off Ver
    16
    Posts
    3

    Help Copy files from one folder and subfolders to another based on a list in Excel

    At the moment I'm using the following code and work perfectly on just folder any idea how to make it search also in a subfolder within the folder
    Many Thanks
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 09-30-2019 at 01:12 PM.

  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: Help Copy files from one folder and subfolders to another based on a list in Excel

    Hello inasr,

    Do you need to search all folders and subfolders in the parent folder?
    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
    09-30-2019
    Location
    London
    MS-Off Ver
    16
    Posts
    3
    Quote Originally Posted by Leith Ross View Post
    Hello inasr,

    Do you need to search all folders and subfolders in the parent folder?
    That's exactly what I'm looking for

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,035

    Re: Help Copy files from one folder and subfolders to another based on a list in Excel

    Administrative Note:

    Welcome to the forum.

    We would love to help you with your query; however, it has been brought to our attention the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

    https://www.mrexcel.com/forum/excel-...ist-excel.html
    https://www.excelguru.ca/forums/show...-list-in-Excel

    I've provided the links for you this time, but in the future, please add all links to the cross post.
    HTH
    Regards, Jeff

  5. #5
    Registered User
    Join Date
    09-30-2019
    Location
    London
    MS-Off Ver
    16
    Posts
    3

    Re: Help Copy files from one folder and subfolders to another based on a list in Excel

    Thank you, Will do

+ 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. VBA Copy specific files listed in Excel from folder & subfolders to another folder - FSO
    By HelloFriends in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2019, 02:55 PM
  2. Copy Files from One Folder to Another Folder based on a List In Excel
    By civram1982 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2019, 06:34 AM
  3. Copy specific files from subfolders to new folder
    By dxl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-28-2016, 06:06 PM
  4. List of files in selected folder and subfolders
    By Un-Do Re-Do in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-09-2015, 04:52 AM
  5. 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
  6. Needs macro to copy excel files from folders, subfolders to new folder
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2014, 08:53 AM
  7. [SOLVED] list of subfolders in folder - without files and sub-subfolders
    By MartyZ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2012, 04:35 AM

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