Print to a pdf but then ADD existing pdfs to the newly created pdf

[carsto]

This workbook creates via VBA (3) sheets name RED, WHITE and BLUE, then it deletes all other sheets and prints a pdf.

I am using ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF to write my workbook to a pdf. THIS WORKS FINE.

I have existing pdfs with known names & file locations I need to tack on to the end of the pdf I just created in excel.

I need to loop through RED, WHITE & BLUE and
Go to a known file location, locate the file named REDxxxxxxx.pdf and add it to the pdf, which now has 4 pages
Go to a known file location, locate the file named WHITExxxxxxx.pdf and add it to the pdf, which now has 5 pages
Go to a known file location, locate the file named BLUExxxxxxx.pdf and add it to the pdf, which now has 6 pages

Can I do this in Excel 2010 via VBA?

[scottiex]

I think you would need to have Adobe acrobat (and not acrobat reader) unless you want to rebuild it every time.
Do you have that?

If you do - then this might help

http://khkonsulting.com/2009/03/adob...-introduction/

[JBeaucaire]

You can, but it is a significant amount of plumbing. To make my life easier in the past and keep it manageable (IMO), I use a different approach typically.

1) I created EXCEL versions of all my "addons", saved in known locations/names

2) When I need to create new PDF with data from a workbook PLUS the addons in a single PDF I would

a) COPY the workbook sheet to a new temp workbook
b) Import the addon workbooks as additional sheets to this new workbook
c) Print the entire new workbook to a single PDF in one shot
d) delete the temp workbook (close without saving, for instance)

[mgs73]

Good news - you don't need Acrobat! Try this:

The AppendToPDF function will add the selected worksheet to the existing PDF, or create a new one if it doesn't already exist. Don't forget to add the Reference to Adobe Type Library. Also note, this code adds the spreadsheet PDF to the end of existing PDF, and if I understand correctly you want to do the opposite. Hopefully with some small modifications it can do what you need.

Please Login or Register  to view this content.