Hi Tim,

I solved the problem. I was making a call to the objWord.Unprotect method
which is why Word was asking for the password.

thanks for your help

"Tim Williams" wrote:

The Word "Open" method has a "PasswordDocument" parameter you can use to
supply the password.

Tim

"Ray C" wrote in message
...
I have an Excel workbook that loops through a bunch of Word documents in a
folder and processes each Word document. The problem is that some Word
documents ask for a password when Excel tries to open it.

Is there a way to bypass this? My client is annoyed each time because he
has
thousands of Word documents to process. He runs it in the middle of the
night
only to find out in the morning that there is a dialog box opened asking
for
a password.

I'm wondering if there is a parameter that we pass to the Open method of
the
Excel object in VBA.


Thanks in advance