Merge PDFs using VBA

[ianclegg]

I have a need to merge 6 pdfs using vba, I have checked all the bullzip pdf writer references but can find no info onto how to configure them.

Can anyone help me or suggest an alternative method.

Thanking you in anticipation


Regards

Ian Clegg

 

[Gasman]

This appears to be one way?

http://www.vbaexpress.com/forum/showthread.php?47310-Need-code-to-merge-PDF-files-in-a-folder-using-adobe-acrobat-X

HTH

I have a need to merge 6 pdfs using vba, I have checked all the bullzip pdf writer references but can find no info onto how to configure them.

Can anyone help me or suggest an alternative method.

Thanking you in anticipation


Regards

Ian Clegg

 

[jleach]

Not familiar with bullzip. I've done it with Acrobat before, but that requires an external installation, which is kind of blah.

Been a number of years, but I used to "borrow" a DLL from Stephen Lebans for this, which can be plopped into the Access root dir and no need for any other dependencies.

The two dlls are here: http://www.lebans.com/reporttopdf.htm


I couldn't find my copy but here's what Stephen has in his own code:

Public Declare Function MergePDFDocuments Lib "C:\VisualCsource\Debug\StrStorage.dll" _
    (ByVal PDFMaster As String, _
    ByVal PDFChild As String _
    ) As Boolean

hth

 

[whomademe]

I use the Debenu Quick PDF Library ActiveX DLL - debenu dot com

A little homework to set up and integrate but once there, is quick to do many PDF related tasks. It's the workhorse for our document manager system.