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