Powershell lookup a password then set it for a user

[ndavies]

Hi all,

 

We have a supply teacher account whose password is changed on a daily basis. Is there any way I can automate this using powershell.

 

1. look up "today's" password in an xml,csv or similar file

2. set it to a variable

3. set the variable to a specific user's account password

 

I think I've found the command for 3, but how can I achieve 1 and 2?

 

Nick