Copy files

[maytey]

Currently I need a function where I can copy back all the workbooks from the different folders into a main folder.
As I need to copy back 160 workbooks, it will save me a lot of time if I can specify the folder path names and execute this function

Thanks!

[mdmackillop]

Have a look at FileCopy in VBA Help.
Do you want to copy all files in the folders? Do you maintain a list of files to be copied? We need some more information.

[Norie]

You might also want to look at Name if you actually want to just move the workbooks not copy them.