+ Reply to Thread
Results 1 to 2 of 2

Vba Code to Open PDF and Save with Password Protected PDF

  1. #1
    Registered User
    Join Date
    09-19-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    1

    Post Vba Code to Open PDF and Save with Password Protected PDF

    Hello Guyz,

    I want the macro which open pdf from selected folder and then save that PDF as Password Protected PDF, and I want to perform action in loop till last PDF file at location selected.

    If one pdf then macro run for one pdf else it need to run for all.

    For Test purpose add default password as "123"

    Please help me,

    Thanks

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Vba Code to Open PDF and Save with Password Protected PDF

    Good afternoon chintamanicv7

    Welcome to the forum.

    Excel cannot save .pdf files as password protected files. Oddly, it seems, Word can.
    You can use a third party application to password protect them on the fly - have a look at answer number 2 in the attached link, but don't expect it to be a simple fix - it's fraught with issues.

    HTH

    DominicB

+ 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] Open password protected PowerPoint from VBA (I know the password)
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2016, 12:29 PM
  2. Running workbooks.open to open pax-protected file still prompts for a password
    By karinincanada in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2015, 05:06 PM
  3. Code to open password protected excel file
    By mdwnn7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2015, 01:00 PM
  4. Open, copy and save to password protected workbook
    By pjbassdc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 11:46 AM
  5. [SOLVED] Password array to open all password protected workbook in a folder
    By rename in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-07-2012, 05:06 AM
  6. Replies: 4
    Last Post: 11-20-2009, 06:18 AM
  7. [SOLVED] How do I save a password protected Excel doc in order to open?
    By Stamperfiend in forum Excel General
    Replies: 4
    Last Post: 08-25-2005, 07:05 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