Script to copy select folders/files based on an external list in a text file

I have a directory on a windows server that contains over 100,000 documents and I would like to copy some of these to a different drive but I need to preserve the folder structure as well.  I have a list of the folder/file names in a text file and would like a script to automate this process.  How would I do this?

For example, the directory has folders/files similar to this:

C:\Files\AAA\File1.doc
C:\Files\AAA\File2.doc
C:\Files\AAA\File3.doc
C:\Files\BBB\File1.doc
C:\Files\BBB\File2.doc
C:\Files\BBB\File3.doc
C:\Files\CCC\File1.doc
...


My text file might contain something like this:

C:\Files\AAA\File2.doc
C:\Files\BBB\File1.doc
C:\Files\CCC\File3.doc

So I would like my script to loop through the list in the text file and only copy those files while preserving the folder structure.  

So the new directory would be:

D:\Files\AAA\File2.doc
D:\Files\BBB\File1.doc
D:\Files\CCC\File3.doc



Thanks
LVL 18
mgcITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kent DyerIT Security Analyst SeniorCommented:
Does this have to be a VBScript?

If not, I would look into the use of ROBOCOPY/FORFILES to do this task.
 
ROBOCOPY is pretty comprehensive in the sense, you can copy whole trees, apply ACLS/etc.
mgcITAuthor Commented:
no, does not have to be VBScript.  Can either of those only copy select files/folders based on a predetermined list?
Kent DyerIT Security Analyst SeniorCommented:
FOR /F "delims=" %%A IN ('type filelist.txt') DO ROBOCOPY %%A D: /MIR

Open in new window


WHERE YOU WOULD HAVE filelist.txt setup as:
C:\Files\AAA\File1.doc
C:\Files\AAA\File2.doc
C:\Files\AAA\File3.doc
C:\Files\BBB\File1.doc
C:\Files\BBB\File2.doc
C:\Files\BBB\File3.doc
C:\Files\CCC\File1.doc

Open in new window


And would MIRROR or duplicate the structure on the D: drive.

Ref. - http://ss64.com/nt/robocopy.html or ROBOCOPY /?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mgcITAuthor Commented:
Thank you
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VB Script

From novice to tech pro — start learning today.