Background:
Our department does not have Adobe Acrobat Pro. We are using Bluebeam Extreme. I have been successfully using PDFTkServer through VBA to automate the process of merging PDF files. Due to the current situation, there is now an increase in the number of digitally signed pdfs received via email or sent to a shared network drive for processing. I am unable to merge these directly with PDFtk or manually with Bluebeam. According to Bluebeam, this is the intended behaviour in order to avoid fraud. A colleague provided a manual work around by opening the PDF in Chrome Browser and click the print button and choose save as PDF. After doing this, I can then use PDFtk or Bluebeam as normal to merge the files.
Question:
Does anyone know if vba can open the pdf and save as via chrome (or some other way) directly so I don't have to stop the workflow and manually do those steps?
Secondary Question:
Might there be vba code that could detect whether the pdf is digitally signed so that I don't have to open and re-save every pdf if it doesn't have a signature? I thought I had found a method using pdftk, although it seemed to work on some test files, it failed when I started receiving new pdfs because it generated an error message that it was unable to open the file.
Our department does not have Adobe Acrobat Pro. We are using Bluebeam Extreme. I have been successfully using PDFTkServer through VBA to automate the process of merging PDF files. Due to the current situation, there is now an increase in the number of digitally signed pdfs received via email or sent to a shared network drive for processing. I am unable to merge these directly with PDFtk or manually with Bluebeam. According to Bluebeam, this is the intended behaviour in order to avoid fraud. A colleague provided a manual work around by opening the PDF in Chrome Browser and click the print button and choose save as PDF. After doing this, I can then use PDFtk or Bluebeam as normal to merge the files.
Question:
Does anyone know if vba can open the pdf and save as via chrome (or some other way) directly so I don't have to stop the workflow and manually do those steps?
Secondary Question:
Might there be vba code that could detect whether the pdf is digitally signed so that I don't have to open and re-save every pdf if it doesn't have a signature? I thought I had found a method using pdftk, although it seemed to work on some test files, it failed when I started receiving new pdfs because it generated an error message that it was unable to open the file.