Using Excel to merge 2 or more PDF documents Into 1 PDF Document

**jonvanwyk** · 10-11-2011, 01:30 PM

I want to create a simple Excel form that allows a user to browse for 2 or more PDF files located on the desktop, and then merge them into one PDF document. It would look something like this:

--------------------

File 1: [Browse]
File 2: [Browse]
File 3: [Browse]
File 4: [Browse]
File 5: [Browse]

Name of New Document: [User Defined]

[Submit Button]

--------------------

The name of the new PDF document would be user defined, but would automatically save to the desktop when "Submit" is clicked.
It would also be appropriate for there to be VBA that would also automatically delete from the desktop the original files that were merged.

Any assistance with this is greatly appreciated!

**royUK** · 10-11-2011, 01:35 PM

I doubt if you can do this with Excel, you would need to use a pdf software

**jonvanwyk** · 10-11-2011, 01:38 PM

I am also trying to research this question online. I found a post on another forum that provided the code below. Do you see this code as meeting my stated needs?

Please Login or Register  to view this content.

**jonvanwyk** · 10-11-2011, 02:16 PM

I am finding some indication that this can be done, but am not advanced enough to decifer if the code will meet my needs; or how to modify it to do so. Below is another example I found:

Please Login or Register  to view this content.

**jonvanwyk** · 10-11-2011, 02:24 PM

I am trying to do the leg work so that you Excel VBA gurus out there can let me know if I am on the right track, or if it is a lost cause.

Here is another example that I have found:

Please Login or Register  to view this content.

**Kyle123** · 10-11-2011, 02:33 PM

Hi, all the examples you have posted use external pdf software to mge the documents. Do you have any software that can do this? You can then look to incorporate this into,your workbook

**jonvanwyk** · 10-11-2011, 02:55 PM

I was afraid that they were using external software. No...this would not be available. I will keep looking...

**Kyle123** · 10-11-2011, 03:16 PM

I'm pretty sure that it's not possible without external software

**jonvanwyk** · 10-11-2011, 03:34 PM

I see a lot of words like "probably" and "pretty sure" being used. You are 'probably' right, but it is worth asking the question, as maybe someone has figured out a solution before.

Perhaps the key is to use Excel to convert the PDF into a different type of document that Excel CAN merge together, and then convert THAT combined file back into a PDF? It seems reasonable to assume that if Excel can convert Excel to PDF, then Excel can convert PDF to Excel. It then seems reasonable that Excel can combine two or more Excel documents into one Excel document, and then convert that one Excel Document back into a single PDF document [for example].