Merging 2 PDF File Under The MS Access 2016

[cheer]

Under the MS Access 2000, the StrStorage.dll is workable if you are using the download library file from http://www.lebans.com/reporttopdf.htm

However, the library file is not working under the MS Access 2016 and error stop at hLibStrStorage = LoadLibrary( "StrStorage.dll") although you have copy the said library file to c:\windows\syswow64 and same directory as the ACCDB

Anyone has experienced before other FREE PDF merging library file besides the one provided by the Laben company ?

 

[sxschech]

I've used PDF Toolkit command line with vba
PDFtk
https://www.pdflabs.com/docs/pdftk-cli-examples/

Join in1.pdf and in2.pdf into a new PDF, out1.pdf

pdftk in1.pdf in2.pdf cat output out1.pdf
​

and also used http://www.khk.net/wordpress/2009/03/04/adobe-acrobat-and-vba-an-introduction/

You need full version of acrobat to use this.
I just realized after I hit send, I have Acc 2013, so haven't yet tested under 2016.

I can provide vba example that I used for pdftk as well as for khk.

 

[cheer]

I've used PDF Toolkit command line with vba
PDFtk
https://www.pdflabs.com/docs/pdftk-cli-examples/

and also used http://www.khk.net/wordpress/2009/03/04/adobe-acrobat-and-vba-an-introduction/

You need full version of acrobat to use this.
I just realized after I hit send, I have Acc 2013, so haven't yet tested under 2016.

I can provide vba example that I used for pdftk as well as for khk.

TQ. I am looking something FREE (library file) to plug into my Access 2016 application.

 

[cheer]

I have tested a free JAVA jar file (pdfsam-console-X.X.X.jar) which can merge more than 2 PDF files

Below is a simple programming that use the pdfsam-console-0.7.0.jar for PDF files merging

Private Sub Test()
Dim strPDFSam_JAR As String
Dim strPDFFiles As String
Dim strPDFOutput As String
Dim strPDFSamMerge As String

strPDFSam_JAR = "java -jar G:\NewI3\I3System\PDFSam-Basic\lib\pdfsam-console-0.7.3.jar"
strPDFFiles = "-f " & strPTFileDirectory & " -f " & strDrawingDirectory
strPDFOutput = "-o " & strPTFileDirectory
strPDFSamMerge = strPDFSam_JAR & " " & strPDFFiles & " " & strPDFOutput & " -overwrite concat"
Shell strPDFSamMerge, vbNormalFocus
End Sub

For download purpose, please access HERE . I have found the pdfsam-console-0.7.0.jar through the version 0.7 stable release 1 . If anyone can detect the JAR file in higher version than 0.7.0, kindly share out at here.

Thanks !

 

[sxschech]

I just remembered another open source option Ghost Script. Haven't tried it since I have full version of acrobat.

https://www.ghostscript.com/

example of a command line merge.

https://gist.github.com/brenopolanski/2ae13095ed7e865b60f5

 

[cheer]

I just remembered another open source option Ghost Script. Haven't tried it since I have full version of acrobat.

https://www.ghostscript.com/

example of a command line merge.

https://gist.github.com/brenopolanski/2ae13095ed7e865b60f5

Thank you for your recommendation

 

[cheer]

I have found the latest JAR version by reading at HERE.

Just not too sure what are the correct parameters for this version pdfsam-console-2.1.0e

 

[Galaxiom]

I have tested a free JAVA jar file !

Using anything in Java opens up some of the worst possible security vulnerabilities especially if it is an old app that uses ancient versions of Java Runtime. Java should be avoided like The Plague.

Why not use the simple pdfTools executable? The command line version is free.

 

[cheer]

Using anything in Java opens up some of the worst possible security vulnerabilities especially if it is an old app that uses ancient versions of Java Runtime. Java should be avoided like The Plague.

Why not use the simple pdfTools executable? The command line version is free.

I need to plug a library or codes into my ERP software. Unless PDFTools provide something free to be used in my application.

Is PDFTools come with a free library file ?

 

[cheer]

I have tested a help provided by PDFSam company. They provide a link for me to download the latest console file which is called Sejda Console.

Below is a simple function provided

Public Sub Merge2PDFFiles(ByVal strPTFileDirectory As String, ByVal strDrawingDirectory As String)
strPDFSam_JAR = "G:\NewI3\I3System\PDFSam-Basic\sejda-console-3.2.33\bin\sejda-console.bat merge"
strPDFFiles = "--files " & strPTFileDirectory & " " & strDrawingDirectory
strPDFOutput = "--output " & strPTFileDirectory
strPDFSamMerge = strPDFSam_JAR & " " & strPDFFiles & " " & strPDFOutput & " --overwrite"
Shell strPDFSamMerge, vbNormalFocus
End Sub