Moving Files from one directory structure to another directory

Hello,

I have a question regarding moving files from one directory to another. I have an excel spreadsheet with a list of file names in Column A. This macro runs through the columns and checks against a directory to see if the file exists, and moves into a destination directory. It runs fine for now, but I was wondering if there was a way to retain the directory structure and create the subfolders within the destination folder.

Please Login or Register  to view this content.

Any help is much appreciated!

The problem I have is that the script will find all the files I listed in Column A from the source folder, but it will simply move all files found from all subdirectories to the new destination folder, all in the same root folder. What I would like is for the script to find all the files from the source folder but move them into the destination and create the subdirectories tied to each.

For example:
If the source folder is C:\source, then the script will find all files within that directory, including subfolders such as C:\source\sub1 and C:\source\sub2. If there is a file found in C:\source\sub1 and C:\source\sub2, the script will simply move all files found into the destination folder C:\destination. What i want is to retain the structure so that when moved, it will save files into C:\destination\sub1 and C:\desintation\sub2.

Hope that clarifies a few things.

Originally Posted by patel45

It's not clear for me

Thanks for your reply, patel45. However, I believe the code you provided will copy all files from the sourcepath to the destpath. What I originally posted was a script to search for files I listed in Column A and move only those specified files into the destination folder. The problem I really need help with is when it finds the files in the source path to mimic the same directory structure (with subfolders) in the destination path.

Thanks again.

Originally Posted by patel45

try this

Please Login or Register  to view this content.