Might have been covered before, but I can't find it...

We've got a set of supply teacher network accounts, that I want to change the password for on a daily basis according to a predetermind list of passwords in a txt, or xls file.

Can I do this automatically using VBS, can anyone give me some hints about how to read the password from the file, match it to corresponding date and set the password to a bunch of users.