Auto Subscribe

[Joaquim Gabriel]

Hi, my name is Joaquim and I'm a VBA developer. And I would like to create a function where I can insert a macro in VBA that automatically signs documents within Excel. I think of it this way: I have buttons that automatically fill out word documents, and name them based on cell C2. Furthermore, when the system finishes filling out, I have the option to print, or generate it as a PDF (wonderful, right?). Taking advantage of this function, I want to "redeem the file I just generated, and sign it with my signature token". Does anyone have tips?

[Thom Parker]

Here's what I would do. Develop the JavaScript code for signing the document in Acrobat.  Once you have it all figured out,  make the code a folder level, trusted JavaScript function.

Then in the VBA, use the Acrobat IAC api to open the document and call the JavaScript function through the JSO. 

You'll find everything you need to do it here:

https://opensource.adobe.com/dc-acrobat-sdk-docs/library/toc.html

Look specifically at the JavaScript and InterApplication Communication references.