This is a video show you my latest work on PDF using VBA. following tasks have been accomplished.
1. user can select a folder from User Interface.
2. user can provide a list of document files and their respected passwords.
3. if the user has selected a folder then pressed the custom-built button then Macro will loop through each file in that folder and check if it is a word document. if it found a document then convert it into an encrypted PDF.
4. if the user has proved links then Macro will loop through each link in the sheet and check if the password is provided then it will convert the docx file to encrypted PDF.
If you need any of the above-mentioned scripts just make a request. I will help you to the best of my knowledge. You will get amazed.
![](https://i.ytimg.com/vi/fv_Kf3qcc-Q/maxresdefault.jpg)