+ Reply to Thread
Results 1 to 4 of 4

Folder search and copy when it found the match

  1. #1
    Registered User
    Join Date
    02-01-2017
    Location
    DOHA QATAR
    MS-Off Ver
    2013
    Posts
    26

    Folder search and copy when it found the match

    Hi! all I need your help... is it possible that you have a list of folder name in range "A" that you need to search in drive C: or any directory after that once its search the match folder name in range "A" it will copy or cut to other folder path to any drive or directory you want it to save. Many thanks in advance

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Folder search and copy when it found the match

    YOu should try Google, it really works.
    For example: a few of the found hits whe searching for "vba excel list folder list to worksheet"
    https://www.extendoffice.com/documen...ist-files.html
    http://www.vbaexpress.com/kb/getarticle.php?kb_id=1042
    http://software-solutions-online.com...n-a-directory/
    https://www.mrexcel.com/forum/excel-...eet-names.html
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    02-01-2017
    Location
    DOHA QATAR
    MS-Off Ver
    2013
    Posts
    26

    Re: Folder search and copy when it found the match

    Thanks for the info but I check all the link that you give none are there. All the link u give are searching for file... all I want is searching for folders in the list range "A" and once it found the match it will copy to the new folder you want it to save...

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Folder search and copy when it found the match

    This was intended as a hint, and idea to help you on the way.
    You can extract the foldername only and then go on to the next loop.
    A little bit of effort on your part ...

+ 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. Macro to copy cells from all worksheets found in all closed workbook in a network folder
    By Chrispelletier in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2014, 10:26 AM
  2. [SOLVED] Match one cell with another, if match found copy adjacent cells
    By Xiophoid in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-07-2013, 05:50 AM
  3. search for a file in a folder based on data, copy and paste it in another folder
    By kboy1289 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2013, 11:47 AM
  4. [SOLVED] Search for a value and if the value is found copy the whole row. And repeat the proces
    By beamonemo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-13-2012, 02:34 PM
  5. Replies: 10
    Last Post: 06-04-2012, 09:38 PM
  6. [SOLVED] INDEX-MATCH function return '0' if search criteria not found
    By Ben.SFM in forum Excel General
    Replies: 2
    Last Post: 04-27-2012, 01:46 PM
  7. Replies: 3
    Last Post: 11-24-2010, 03:57 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