Add Digital Signature To PDF Using VBA

[in.vaibhav]

hey folks,

i have many PDF's that i wanna sign using digital signature ".pfx" file.

Is it possible to do using VBA & how we can do it.

Thanks in advance for all help.

[Excel Fox]

Crosspost Add digital signature using excel VBA to PDF - VBA Express Forum

[in.vaibhav]

Crosspost Add digital signature using excel VBA to PDF - VBA Express Forum

yeah, coz there was no response on question asked..

[Excel Fox]

Vaibhav, the cross post is just highlighted for volunteers to keep a track of whether someone has given a solution elsewhere or not, and not to spend their free time wastefully. I'm sure you'd appreciate that it's just a matter of informing the forum that this has been cross posted on another location.

[Robin77]

To add a digital signature to a PDF using VBA, you’ll first need to ensure you have a PDF library that supports signing. With Adobe Acrobat or a similar tool, you can use VBA to interact with the PDF through the library’s COM interface. Write a VBA macro to open the PDF, access the signature field, and apply the digital signature using your certificate. Remember to handle any security prompts that may appear.

[kirin999]

I've been stuck on this exact issue too! Adding digital signatures to PDFs using VBA can be a real pain. Robin77's suggestion to use a PDF library with a COM interface makes sense, but I'm still unclear on how to implement it.