Move files to specified folder

[dummies]

I have 2 folder,
1. Temp, which contains many sub folders(department or course)
2.vba , it contain files(name of the students) of the every students.
I am done with creating files and folders of every students and their department, but i am stuck with how to move files to specified folder.
Like if student A is in commerce department, i want to move that student A to commerce folder. Like wise is student B is in science, move student B to science folder, and so on. (Some students have same department as well). And all the moved file should be password protected(password should be last 4 digit of their date of birth)
It will be great help if any one could help me with this. I am really stuck here.
Thank you in advance.

 

[offthelip]

that is an entirely different problem because it involves opening each file to look at column G and then save the file with a password, The code I have written just renames the file it doesn't open the file. I suggest you post this as a new query

 

[dummies]

that is an entirely different problem because it involves opening each file to look at column G and then save the file with a password, The code I have written just renames the file it doesn't open the file. I suggest you post this as a new query

Okay thank you.