+ Reply to Thread
Results 1 to 2 of 2

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

  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

  2. #2
    Registered User
    Join Date
    11-28-2019
    Location
    K.L
    MS-Off Ver
    2010
    Posts
    12

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

    i need to learn about this too

+ 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. [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