Copy files based on List

  • I'm attempting to copy files from one folder to another, based on a list. ( ie: Column A is the origin, column B is the destination folder)

    But I'd like the directory path to be incorporated in this list. ( not be part of the code itself.)


    An example, to move a list of files from the directory in column A to column B


    A..........................................................B


    C:\Test\Folder01\Image1.jpg........C:\Test\Folder02\

    C:\Test\Folder01\Image2.jpg........C:\Test\Folder02\

    C:\Test\Folder01\Image3.jpg........C:\Test\Folder02\


    Thanks for any help!

  • See if the following works :


  • Thanks, Logit


    Although not quite what I was looking for.


    The script itself should not contain any path directories.

    I'm relying on the cells from Column A, and Column B to contain the path directory and file name.


    A script to essentially say:


    Copy all files listed from the directory path listed in column A

    Paste in the directory path listed in Column B

    Each row is assigned to their own unique path directory.


    from A1 to B1

    from A2 to B2

    from A3 to B3

    etc..


    Hope that helps..

  • Try this :



    The above macro presumes your files to copy begin on Row 2 in Col A.