Batch removal of word doc password

[dotobi]

Hey

Does anyone know how to remove the password from all the word documents in a folder?

The password is the same for all docs.

We're using word (office basic) 2003.

THANKS!

 

[fredericofonseca]

use the filesystem object to get a list of documents to change

then open the document, issue a save as with a blanck password, close the document.


For code in the filesystem object you can search these forums for samples.

For code on opening, saving and closing the documents, turn on your macro recorder, perform the required operations, close recorder and then look at the code created.

Adapt to use a dynamic file name and you will be fine.

Once you have some code come back to us if you have any problems with it.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[PHV]

If you don't have to deal with SubFolders you may consider the Dir function instead of FileSystemObject.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886