Open password protected document

[TRM]

I am trying to use VBA to open a password protected document for editing. I
have tried putting the password in the code after the open statement
(odoc.password = "password"). But, of course, this is opening the document
first, and not checking/seeing the password, so the user is still prompted.
Is there a way to do this?

Thanks!

 

[Tony Jollans]

The Open method has several password options - depending on the type of
password, simply ..

Documents.Open FileName:="C:\path\file.doc", PasswordDocument:="whatever"