How to Password Protect PDF Files using VBA

Показать описание

This is probably one of the most requested topics I got from my mail merge automation video. In this tutorial, we are going to look at how to use VBA in Excel to password protect a list of PDF files.

Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
🔑Venmo: @Jie-Jenn

Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#VBA #PDF #Encryption

Jie Jenn

Рекомендации по теме

Комментарии

There is a space after the exe path. ".exe " -> yes
".exe" -> no

jiejenn

This is very helpful, thank you very much for sharing

shinli

Excellent tool and thanks for sharing. Can we use the same tool to encrypt pdf to prevent editing or copying not password to open?

fksoftware

You are amazing!!! This helps me a lot! Thanks!!!

sergioaguirre

Hi thank you for the program. However when I ran it, it does not automatically fill the PDFEncrypt menu. I need to type in. Do you know why? Thanks

aidianyingren

Thanks excellent Video but it had encrypted only one file out of 3 when I run first time and 2nd time nothing happen

amitmishra

Hi jie

Can you make a video on creation of exe file

abhishodhds

Hi, can u help me, the application can’t working, i got notif
encrypt_pdf.exe: error: following arguments are required: password
Pls help to solve. Thank you 🙏🏻

mariomakarawo

Can you share the decompiled python code, I'm seeking to encrypt the pdf file with two passwords (owner and user) ?

abdelrhmanmohamed

Hey, can i merge this module into a separate module so that the mail merge, creation and encryption could be done together rather than seperate modules??

DeadbeatGaming

Excellent tool! Many thanks. One thing i was wondering is why is the .exe so big, I'm guessing it's because there are a number of heavy runtimes that you need?

DrJohnners

Hi, this looks amazing! But is it possible to apply the macro to the pdfs instead of the .exe file?

purplemoorselle

I want to use your method but i cant. Excel show Error "Object doesn't support this property or method". Do you know why? I have Office 2019 Home edition.

MrMarek

Hi, I am receiving the message "runtime error'53': file not found". I have seen other comments where you said to specify the file location in a variable to point to the binary. Can you explain how to do that? Where should it be included in the code?

dominic

Hello, I copied the code exactly written, installed the encryption tool and when I run the macro, nothing happens. I open the pdf and there is no password. Do you have any advice?

jessefreitag