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.
Bookmarks