I need help encrypting multiple PDFs with unique passwords. I want to incorporate this feature within Excel VBA. I plan to have a worksheet that lists out the file name/path in column A and the desired password in columns B. Using a loop, it will encrypt each file with a different password. Is something like this possible in Excel? If not in Excel, then what are my other options?
Acrobat doesn't have any API suitable for this.