Password Protect Word Doc Through VBA

[bharath744]

Hello,

I have a word doc in the same folder as my access application. At the click of a button I want the access application to password protect my word doc without opening it (atleast not visible to the user)

Consider my word doc name as "MyWord.doc"
Password as "testPass"

Thanks in advance.

 

[darbid]

I would suggest you just open word, open the document, add a password and close the document and word. If you do not make word visible then the user will not see anything, although he will notice that his CPU usage changes as word is called.

see here on the password part http://msdn.microsoft.com/en-gb/library/aa196352(office.11).aspx