Feb 17 2011, 08:10 PM
I utilize several reports that contain sensitive personal information about an employee. I want to email the saved PDF to certain executives.
I found the code below in one of the forums.
DoCmd.OutputTo acOutputReport, "anyreport", acFormatPDF, "c:\myfile.pdf", False
Does anyone know if it is possible to password protect the file using VBA? A buddy suggested I create a zip file with a password using VBA and then email the zip file.
Feb 18 2011, 12:00 AM
You can password the PDF itself on the menu bar File>Properties then follow the prompts
Feb 18 2011, 11:54 AM
I think you are going to have to use the pdf API reference if you want this done automatically. I had previously needed to do some pdf manipulation and downloaded in July 2009, “acrobat_pdfl_api_reference.pdf" from adobe but cannot find it anymore, there are several other API references I was able to find currently. Icouldnt attach it, it is 44MB. I have to admit that when I was dealing with the references I got most of what I wanted, but not password because I found the reference hard to understand: what it did, what could be used and how, but I was not schooled in their thoughts.
Hope that is a starting point and if you get vba code for it, please post.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here