How Can I Use Excel to Unlock and Copy Password-Protected Word Documents?

Khyat Dattani
Dear All, I have 100 documents in a folder, all of which are password-protected with unique passwords. I have an Excel file that contains the names of these documents and their respective passwords. I need a macro that, when executed, can create password-free copies of all these Word documents.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute