I’ve spent several hours trying to get PDFCreator to work with excel VBA scripts. I did get the .com example for MS Word to work.
Specifically, I need to loop through all the sheets in a workbook, producing one PDF for each, which is encrypted and password protected.
I can do these things from the PDFCreator program interface, but it would take hours to do this for 100’s of sheets, and then to repeat when changes occur.
A simple script, that works with excel, to produce ONE encrypted, password protected PDF, under program control (file name, directory, sheet name, etc.) would be enough. I’ve scoured the Internet but cannot find one for version 3.x of PDFCreator. Any pointers/examples/suggestions are appreciated.