Combine multiple PDF off Single Input

[MH350]

I have an existing database where I can enter in a test pack number, hit a button and combine the various PDF files associated.

However this relies on me finding all the drawings associated and combining them into a binder first which then uses FileCopy.

eg:
FileCopy "\\wheatpfs01\Group\Dept\Completions\Test Pack Native Files" & TP & "\Iso.pdf", mypath & "" & "20.pdf"

I have an excel file that links the test pack no. to the drawings that are part of that pack:

eg:
Test Pack Isometric Doc No
TP001A L790-DX-ISO-10137.002 V-31D4-TNK-1-R7186
TP001A L790-DX-ISO-10137.003 V-31D4-TNK-1-R7187
TP001A L790-DX-ISO-10137.004 V-31D4-TNK-1-R7188
TP001A L790-DX-ISO-10137.005 V-31D4-TNK-1-R7189

Is there a way that I can enter the test pack number and combine all of the drawings (PDF) for this pack? All of the drawings are in the one directory.

My logic works like this in my head:

Enter "TP001" and hit Combine button.
Code goes to directory "X" and combines V-31D4-TNK-1-R7186 / R7187 / R7188 / R7189 into the one PDF.

Apologies if this seems a bit confusing, I am confusing myself and I've been awake since 4am :banghead:

 

[The_Doc_Man]

While Access might be able to produce single output files as .PDF they do not manipulate existing such files so well. The ideal way would be if you had a copy of the Acrobat or other utility that could read, decompose, and manipulate a final document using VBA. I think that you need a licensed copy from Adobe to do that.

The alternative would be if you could create a Word document containing the required combination of components also in Word, and then after it is all built, use the Word Application Object to output THAT combination document as .PDF so you can get what you wanted.