Hello all,

I have created a fairly basic macro to export the current worksheet as a PDF which seems to work nicely.

Sub export()
ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:="R:\" & ActiveSheet.Range("C3").Value, _
OpenAfterPublish:=True
End Sub


However a have a separate document, in PDF format, which I would like to add in as the final two pages of each PDF exported from my spreadsheet.

Is there a way to do this, other than actually replicating the (very wordy) PDF in a new tab in my Excel spreadsheet?

Any help appreciated.

Thanks,