+ Reply to Thread
Results 1 to 2 of 2

Password Protect Folder of PDFs

  1. #1
    Registered User
    Join Date
    02-10-2020
    Location
    Manchester, England
    MS-Off Ver
    365
    Posts
    19

    Unhappy Password Protect Folder of PDFs

    Good Afternoon All

    Scenario:
    I've been approached by a department in regards to creating a solution for a monthly invoicing process. At the moment they manually send out each email with a copy/paste message and attach a PDF that they have already manually added a password to. I've managed to address automating the emails and attaching the PDFs, but I've been asked if there is any way of automating the final step. The current process dumps around 300 PDFs into a folder which is where they are picked up and manually adjusted.

    Is there any way within VBA to apply a Password to all the files within a set folder?
    We have reference data so that each file could be identified and given a separate password.

    I'm just struggling as some sites are saying it can be done but aren't clear, others say it is impossible without a 3rd party plugin. I doubt the company I work for will allow the 3rd party plugin, however that only appears to be for exporting the files from source, not updating existing PDFs.

    Any help would be greatly appreciated.

    Many Thanks, Chris

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Password Protect Folder of PDFs

    Unfortunately, VBA doesn't have built-in methods to work PDF files. A work around is to use a 3rd-party software or if you know other programming languages like Java, Python, C#, etc, then it is a simple task to apply PDF password to a set of files.

    Here's a video reference to add a password to a PDF file using Python https://youtu.be/KGJ1LMTOefY.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Password Protect Folder
    By GeeWhiz04 in forum Excel General
    Replies: 1
    Last Post: 07-13-2015, 10:53 PM
  2. Password-protect excel files in folder
    By ilsley_excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2014, 06:40 AM
  3. [SOLVED] How to password protect a complete folder in excel
    By daisys_dad in forum Excel General
    Replies: 0
    Last Post: 08-10-2006, 09:35 AM
  4. [SOLVED] Password protect a folder with several workbooks
    By tbugs in forum Excel General
    Replies: 2
    Last Post: 08-07-2006, 04:10 AM
  5. How can I password protect a folder?
    By NSharp in forum Excel General
    Replies: 2
    Last Post: 05-18-2005, 06:06 PM
  6. [SOLVED] Can you password protect a folder.
    By Shrimp913 in forum Excel General
    Replies: 1
    Last Post: 03-04-2005, 04:06 PM
  7. Can you password protect a folder?
    By Shrimp913 in forum Excel General
    Replies: 1
    Last Post: 03-04-2005, 02:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1