pulling files from a folder...

[cmefly]

Hi,

I've got a main folder with 88 folders inside (each folder is for a different client so they are named differently). However, each of these 88 folders has a sub-folder called "final results" and within it, there is an excel file called "2011_Jan_results_CLIENTNAME.XLS".

c:\main folder
88 files within this folder
an example is:
c:\main folder\client_name
and in each of the client's folder is a subfolder
c:\main folder\client_name\final results
c:\main folder\client_name\final results\2011_Jan_results_CLIENTNAME.XLS

I need to get all these files ("2011_Jan_results_CLIENTNAME.XLS") into one folder called "all client final results"....

is there such a code that can help me COPY these files into the new directory?

thanks,

Marc

 

[Weaver]

Does it have to be code?

You could do a search for "2011_Jan_results*" in Explorer and then drag the results into your new folder.

If it does have to be code, it is possible.

 

[cmefly]

umm...hmm..the search sounds great...why didn't i think of that!! lol

 

[cmefly]

Weaver,

can you please post a code or link to a code? i'm having trouble copying and pasting a large amount of files...server issue...

thanks,

Marc

 

[Weaver]

There's some stuff here that might get you started. The OP wanted a directory listing, so you could tweak it to get filenames and paths then move the files to another folder.

HTH