Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Copy specific workbooks from one folder (including sub-folders) to another

    I have a macro that copies workbooks from one folder to another

    I would like to specify which workbooks to copy by specifying these in Col A on sheet1

    It would be appreciated if someone would kindly amend the code accordingly
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi Howard

    ..working on an update for you.

    Will post a new file to allow you to specify files to be copied.


    zeddy

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Zeddy


    Thanks for letting me know. Look forward to receiving the updated workbook


    Howard

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi Howard

    ..the attached file might do the trick.

    You must enter the source and destination folders as before (or use the buttons to browse and select the required folders).
    You can either click the [List files..] button to list matching files (and then delete the rows of files you don't want) or type the names of required files, below the header starting in cell [B11].

    zeddy

  5. The Following User Says Thank You to zeddy For This Useful Post:

    HowardC (2016-04-02)

  6. #5
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Zeddy

    Thanks very much for all your help. I have tested the macro and it works perfectly



    Howard

  7. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi Howard

    ..thanks for the feedback. Feedback is always nice to get. Otherwise we wouldn't know.

    zeddy

  8. The Following User Says Thank You to zeddy For This Useful Post:

    Jaggi (2016-04-04)

  9. #7
    2 Star Lounger
    Join Date
    Feb 2015
    Posts
    128
    Thanks
    19
    Thanked 1 Time in 1 Post
    Hi Zeddy,

    Fantastic! This is truly a genius approach.

    Regards,
    Jaggi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •