Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Password protect multiple documents

2 views
Skip to first unread message

Gdareos

unread,
Jun 29, 2008, 9:11:33 AM6/29/08
to
I have an assignment that calls for me to password protect hundreds of
.doc files.

Can I write a macro that will password protect multiple documents
without manual intervention.

Further, I do have some files that are password protected, and I'm
supposed to change their passwords, so I would need a macro that would
open a document, and change the old password to a new one.

Thanks for any help :)

George (baffled in Houston, Tx)

Doug Robbins - Word MVP

unread,
Jun 29, 2008, 3:35:33 PM6/29/08
to
You could modify the code in the article "Find & ReplaceAll on a batch of
documents in the same folder" at:

http://www.word.mvps.org/FAQs/MacrosVBA/BatchFR.htm

to do what you want. You will find the Syntax for supplying the password if
you check out Documents.Open in the VBE Help file.

Also take a look at the article "Skipping Password-Protected Documents in a
Batch Process" at:

http://www.word.mvps.org/FAQs/MacrosVBA/CheckIfPWProtectB4Open.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Gdareos" <gDareos_at_la_louisiane.com> wrote in message
news:902f64pm0kr2hh4e6...@4ax.com...

Gdareos

unread,
Jul 2, 2008, 9:37:47 PM7/2/08
to
This is super helpful, and I'll check it out over the weekend.

Thanks! Thanks! Thanks!

George

0 new messages