Create a single PDF from multiple Hyperlinked PDF's in consecutive records

[MDavidCrompton]

Hi, I am looking for Access VBA code which will create a PDF file and then append a series of hyperlinked PDF files to that file.




The storyline is; My product database has a hyperlink in each record to a PDF Spec Sheet – typically 1 to 3 pages. When I have prepared a quote or confirmed an order I want an order-specific catalog as a PDF with the spec sheets of all products included in the order. Must be a useful enough scenario for someone to have figured it out.

Any help would be most appreciated.

[June7]

Review:

https://www.accessforums.net/access/...pdf-25574.html

https://www.accessforums.net/import-...ges-25042.html

Extract the file path from hyperlink using HyperlinkPart:

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

Just in case you need more info on how hyperlinks are structured:

http://www.allenbrowne.com/casu-09.html

[MDavidCrompton]

Many thanks. I have had a quick look at the links. Exporting multiple re[ports to a single pdf will be very useful in its own right. I have yet to find out if I am clever enough to piece the rest together. Unlike exporting a report the hyperlinks already exist and are all in the same folder. I can use HyperlinkPart to get the full path, which is great. Now, somehow, I want to loop through records to merge the files, not loop through files in a folder.

[June7]

So you need to loop through records to extract the file path and use the file path to locate the PDFs that need to be merged? The code will use the path to open the PDF files as objects to be manipulated. Take this one step at a time. First get the opening and looping through a recordset working. Then inside the loop, extract file path from hyperlink. Then incorporate the Adobe code to manipulate the PDF objects. Test and debug each stage and don't move forward until each works.

[MDavidCrompton]

Thanks again. I'm leaving this open and will let you know how it goes. Then, with luck, I'll mark it solved

[MDavidCrompton]

OK, fallen at the first hurdle, looking into this I guess I have to have a full version of Adobe for the library reference to work. Can it be done in Word??

[June7]

I expect the issue will be the same as far as programmatically manipulating PDF files. If Adobe Pro is required to be installed, doesn't matter where the VBA is.