EXP Systems Forum: Merging PDF Documents

Message

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

Author	Message
keithcrowdy Newbie Joined: 28 Dec 11 Location: United Kingdom Posts: 5	Topic: Merging PDF Documents 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
	IP Logged

Michel_K17 Moderator Group Forum Administrator Joined: 25 Jan 03 Posts: 1673	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 [here]. Cheers!
	Michel Korwin-Szymanowski EXP Systems LLC
	IP Logged

keithcrowdy Newbie Joined: 28 Dec 11 Location: United Kingdom Posts: 5	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?
	IP Logged

Michel_K17 Moderator Group Forum Administrator Joined: 25 Jan 03 Posts: 1673	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
	IP Logged

keithcrowdy Newbie Joined: 28 Dec 11 Location: United Kingdom Posts: 5	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
	IP Logged

keithcrowdy Newbie Joined: 28 Dec 11 Location: United Kingdom Posts: 5	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
	IP Logged

keithcrowdy Newbie Joined: 28 Dec 11 Location: United Kingdom Posts: 5	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
	IP Logged

ArnoldLee Newbie Joined: 14 Mar 12 Location: United States Posts: 1	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. -Tire Works
	IP Logged

Programming
EXP Systems Forum : PDF reDirect : Programming