Moving subfolders to another folder.

[[email protected]]

I have a folder named Directory. Within the Directory folder, there are about 3,000 subfolders. I have to pull out about 1,000 of these subfolders. Each subfolder is named after an employee; last name, first name.
I have an Excel spreadsheet and in column A is the name of the employee that needs to be pulled out of the Directory folder. So for example, if Jones, Mary is in column A2, then the macro needs to identify Jones, Mary subfolder and move (not copy) the subfolder and its contents to another folder. So in the end, I will have a thousand subfolders in one folder. Also in Column B there are some employee ID numbers associated with each name in Column A. If there is an employee ID number, can that be attached to the file name, eg. Jones, Mary – 11223?

If you have another idea on how to do this, I am open for suggestions. Thank you very much.

[shg]

Completely untested:

Please Login or Register  to view this content.

[[email protected]]

Hi. Thank you but nothing is happening when I test this macro.

[shg]

That's not much help.

What's the exact code you're using? What happens when you step through it?

[[email protected]]

I am using the code below. Changing the to and from path. No action occurs when i run it. No errors either.

Please Login or Register  to view this content.

[shg]

You're missing the trailing path separators on the directories.

[[email protected]]

OK.. I added the trailing path separators but still nothing is happening. I have the From folder sitting on my desktop as well to To folder. In the From folder I have a subfolder named Abbatiello,Phillip.

Nothing is happening when I run the code below. I also uploaded the Excel file I am using.

Please Login or Register  to view this content.

.

[[email protected]]

Hi. Also I found some VBA code that just moves subfolders to another folder. Does this help?

Please Login or Register  to view this content.

[shg]

There's no extension in the filenames ...

[[email protected]]

This is a folder name not a file.

Please Login or Register  to view this content.

[shg]

I completely missed that.

Please Login or Register  to view this content.

[[email protected]]

Hi. Thank you this worked great.

[shg]

You're welcome.