I tried the last code adn it still does not enter in the password when the prompt comes up.
It does update the file when I enter in the password.
How does Excel get a password passed to it?