+ Reply to Thread
Results 1 to 1 of 1

Copy Files from one folder to different folders based on pdf file name

  1. #1
    Registered User
    Join Date
    03-15-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Copy Files from one folder to different folders based on pdf file name

    Hi!

    I'm stuck on this problem.

    I have the table as seen on the workbook attached.
    I have the source path and target path, file names etc as seen on the sheet.

    My goal is to copy the files from the source path (which is always the same), to the target path (which as you can see from the sheet, it has different number of subfolders and the last folder is part of the file name that needs to be moved there).

    I almost forgot to mention that the column F where the file names are, not always corresponds to the correct path in column E. Ideally they should be 1 to 1 in the same order, but they are not, since I'm populating the file names using another module.

    How do I loop to make sure it grabs the corresponding file for the correct path?


    How can I achieve that?

    I have also ask this question at:
    http://www.ozgrid.com/forum/showthre...254#post699254

    Thanks a lot in advanced for your help!

    T.
    Attached Files Attached Files
    Last edited by jtammyg; 01-23-2014 at 12:57 PM.

+ 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. Copy Files to Folders Based on Specified File Names and Directories.
    By mamero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2013, 12:08 PM
  2. Replies: 1
    Last Post: 09-12-2013, 09:23 PM
  3. Getting all sub folders and files within a folder
    By UsmanBPD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2013, 08:13 AM
  4. 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
  5. dir all files in a folder and sub folders
    By Pero in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-19-2009, 12:28 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