Hi there,
I have created a macro to pdf certain tabs from a workbook. Easy enough but and I am looking to add an already existing pdf to the macro pdf once it is created. I currently have this code which is simply the code to create the pdf.
Can anybody provide some assistance so that I can add in a pdf that already exists in to the macro pdf? It would need to be entered as the first page and go before any of the pages in the macro pdf.
I have created a macro to pdf certain tabs from a workbook. Easy enough but and I am looking to add an already existing pdf to the macro pdf once it is created. I currently have this code which is simply the code to create the pdf.
Code:
Sub PDFReport()'
' PDFReport Macro
'
'
Sheets("Page 1.1").Select
Sheets(Array("Page 1.1", "Page 2.2", "Page 3.3", "Page 4.1", "Page 5.1", "Page 6.1", _
"Page 7.1", "Page 8.1", "Page 9.1", "Page 10.1")).Select
Sheets("Page 1.1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
ThisWorkbook.Path & "\" & Left(ThisWorkbook.Name, InStr(ThisWorkbook.Name, ".") - 1), _
Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True
End Sub
Can anybody provide some assistance so that I can add in a pdf that already exists in to the macro pdf? It would need to be entered as the first page and go before any of the pages in the macro pdf.