I have a requirement to copy files from one folder to another. The set up is as below
Range A1 To A10 will have the file name
Range B1 to B10 will have the current folder name
Range C1 to C10 will have the destination folder name ( this is where the file should be copied to )
I want to use the FileCopy method ( or any other method for that matter ) to loop through the range B1 to B10 and copy the files to the folders mentioned in C1 to C10
Thanks For Your help in advance.