Results 1 to 2 of 2

Protect multiple pdf with different password from Excel at once using VBA

Threaded View

  1. #1
    Registered User
    Join Date
    08-01-2016
    Location
    Chennai
    MS-Off Ver
    2010
    Posts
    9

    Lightbulb Protect multiple pdf with different password from Excel at once using VBA

    Hi,

    I need experts help to create a vba
    Something like same as shown in video : youtube.com/watch?v=5qA2uGLfmGE&t=53s

    This is needed for monthly repeated salary slip work. (i have the pdf file readily available without password from another system)

    i would like to use excel vba steps to encrypt the file:

    1. Define Folder path to give input for Macro
    2. List down the file names in Column A cells with 100 rows (only pdf to be listed from a folder even if the folder consists of multiple file formats)
    3. Enter password in Column B against each file name.
    4. Mass save & create encrypted multiple pdf file with different passwords in new Folder path.

    Guide me , if i need to buy any additional plugin to make this happen.

    your suggestion will help for my daily work and will reduce the manual entry time.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to password protect a multiple tab in a workbook in excel
    By MetteGaga in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-05-2017, 10:29 AM
  2. Replies: 4
    Last Post: 09-01-2017, 06:36 AM
  3. How to pull data from multiple excel file with password protect
    By mohiking in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2017, 01:51 PM
  4. [SOLVED] VB Code Password Protect Multiple excel files
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-25-2015, 07:14 PM
  5. Protect/Un-protect multiple sheets with password using VBA
    By Max_excel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2013, 02:59 AM
  6. Password Protect Multiple Sheets
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-08-2011, 02:27 AM
  7. Password Protect - Multiple Passwords
    By aspears in forum Excel General
    Replies: 0
    Last Post: 12-08-2008, 01:12 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