Looping File Movement From a Number of Folders to One Folder

Hey Leith, thanks for responding! So I'm trying to understand how exactly I would use the "to" and "from" functions as arguments in a loop. I want the "To" folder to be the same folder that receives the contents of a large number of "from" folders. Would I need to have put the list of folders into the 2nd string of code you have written above in order to have the first string of code loop through all of them?

Hi..

If your list of Folder paths is in Column A (starting in Row 2).. this will do what you want I think..

Change the strDest value to suit..

Please Login or Register  to view this content.

I am not sure why.. but at first I thought you wanted ALL files from ALL Subfolders from a SourceFolder moved to a Destination Folder..
So I'll post the code i made initially to do that also..

Please Login or Register  to view this content.

Apo,

Do I need to put the list of folders into an Excel document? Or is there a way to list them in the VBA code and use something like the call function to cycle through them?

You could put them into an Array and loop through that array if you don't want to use sheet values..

Hey guys, I'm sorry but I guess I'm not really following along. I've been playing with the codes for the last few hours and haven't been able to put them into a workable order. The above code in my initial post moves all files from the folder "UserAnalyticsReports2" to the folder "MasterUserAnalytics". I've been trying to use Leith's suggestion of making the "Frompath" an argument so that it can be amended to refer to a variety of folders. Maybe this isn't the optimal way, but I'd like to combine the initial code with a loop function and a list of folder paths in VBA so that the code loops through each folder in the list, moving the files in each folder to the hard-coded "ToPath" folder, which in this case is "MasterUserAnalytics". Sorry if this is already clear, its all a little above my head at the moment! Appreciate all the help so far.