Programming : Merging PDF Documents

Print Page | Close Window

Merging PDF Documents

Printed From: www.exp-systems.com
Category: PDF reDirect
Forum Name: Programming
Forum Discription: VBA and Batch Tools to control PDF reDirect Pro
URL: http://www.exp-systems.com/Forum_exp/forum_posts.asp?TID=836
Printed Date: 24 Nov 24 at 11:20PM

Topic: Merging PDF Documents

Posted By: keithcrowdy
Subject: Merging PDF Documents
Date Posted: 28 Dec 11 at 10:57AM

Hi,

I have only just come across PDF Redirect, I am trying to write a small VBA Application that sits in Excel 2010. I am using Excel to pull in data from other excel spread sheets and then once down I am opening an Word template and populating it.

This I have got working, what I then need to do is save the Word document as a PDF and then merge a number of Manufacturers PDF Datasheets to the rear of my document as appendices.

This was where I got stuck and came across PDF Redirect, so I downloaded and registered for the full addition.
Gong t through some of the articles on the site there are a number of other people doing the same, but I can't seem to see how to do this. So any assistance would be greatly appreciated

Thanks

Keith Confused

Replies:

Posted By: Michel_K17
Date Posted: 28 Dec 11 at 11:27AM

Hello Keith,

   Have you also downloaded and installed the PDF reDirect ActiveX component for programmers? This download also includes an Excel VBA sample that gives sample code for merging PDF files.

   It's available [ http://www.exp-systems.com/Forum_exp/forum_posts.asp?TID=629 - here ].

   Cheers!

-------------
Michel Korwin-Szymanowski
EXP Systems LLC

Posted By: keithcrowdy
Date Posted: 30 Dec 11 at 12:36PM

Michel,

I have produced the following code: in my Excel Spreadsheet:
Private Sub cmdPDFBatch()

    Dim oPDf As New PDF_reDirect_Pro_Tool
    Dim DestFolder As String
    Dim PDF(10) As String
    DestFolder = Cells(11, 5)
        For i = 68 To 80
            If i < 74 And i > 75 Then
                PDF(i - 68) = Cells(i, 6)
            End If
        Next i
    oPDf.Utility_Merge_PDF_Files DestFolder, PDF

End Sub

What I have is, in the cells (68,6) to (80,6) is the path of the pdf's I need to merge and in Cells(11,5) I have where it is to be saved to.

When I run the code I get "Run Time error '429'.. ActiveX Component can't creat object.

Any Ideas what I am doing wrong?

Posted By: Michel_K17
Date Posted: 31 Dec 11 at 5:30PM

Hi,

Error 429 is saying that you do not have a reference made to the DLL in your VBA Excel project. You can do this by going into the VBA IDE, and then going into Tools >> References >> and selecting "PDF reDirect Remote Control".

If the above does not work, try the following:

Look to make sure that the ActiveX DLL (ActiveX_PDF_Pro_v25002.dll) is located in the following folder: C:\Program Files (x86)\PDF reDirect.
If it is not there, then you might find it here: C:\Program Files (x86)\PDF reDirect\ActiveX. If it is there, then move it to: C:\Program Files (x86)\PDF reDirect
Register the ActiveX manually using the Regsvr32 command as follows:

Open a Command Prompt. In Windows 7, you can type "cmd" in the Search box, and then right-click on "cmd.exe" and select "Run As Administrator".
In the command prompt, type the following:

C:\regsvr32.exe "C:\Program Files (x86)\PDF reDirect\ActiveX_PDF_Pro_v25002.dll"

A message will come up saying that "DllRegisterServer ActiveX_PDF_Pro_v25002.dll succeeded"

Go back to the Excel VBA IDE, and try again to add a reference to the ActiveX DLL.

Hopefully this will do the trick for you.

Cheers!

-------------
Michel Korwin-Szymanowski
EXP Systems LLC

Posted By: keithcrowdy
Date Posted: 01 Jan 12 at 5:52AM

Hi,

Looking in C:\Program Files (x86)\PDF redirect I have “ActiveX_PDF_Pro.dll” but not “ActiveX_PDF_Pro_v25002.dll”

When I look at it properties I see it is version 2.2.06

I don’t have a sub-directory “ActiveX”

I have currently:

· Quick PDF Library 7.18

· PDF_reDirect_2500

· PDF redirect Pro Remote Control

Referenced in Excel

So I assume I have the correct DLL registered? or have I?

Thanks

Keith

Posted By: keithcrowdy
Date Posted: 01 Jan 12 at 7:24AM

Hi again,

moving forward albeit slowly - Found one problem my batchprinter hadn't installed correctly. Got that sorted now.

Now the code is recognised, however when it runs it is coming up with

Run Time error '429' -ActiveX component can't create object" - I am running Windows 7 X64 but I running office 2010 X86

Keith

Posted By: keithcrowdy
Date Posted: 01 Jan 12 at 11:06AM

I have done a re-install and now have “ActiveX_PDF_Pro_v25002.dll" in the directory and have registered it.

So now the line "Dim oPDF As New PDF_reDirect_Pro_Tool" needs updating so I changed it to "Dim opdf As New PDF_reDirect_v25002"
and it came up with a comile error: Expected user defined type, not project

Posted By: ArnoldLee
Date Posted: 14 Mar 12 at 3:42PM

whether its to cut down on folder clutter or speedily send a single attachment, merging separate PDF files into a single document is a snap. - http://informationation.wordpress.com/2010/12/14/tire-works/ - Tire Works

Print Page | Close Window