Collate pdfs to one file

[jnvm90]

Hi guys,

I am trying to figure out if there is a way to collate pdf's together in VBA.

I have currently written a macro that changes filters for a couple of pivot tables based on a list of variables that I am looping through.

Example of above. My filter is a company name and I have a list of companies that I loop through.

For each of these loops I update my sheets and I want to print a copy of the sheets to a pdf file. However rather than ending up with 20 different pdf files (one for each loop) I want these outputs to be compiled into one pdf file.

Example of above For each company name I calculate the financials of the company and I want to print those financials. Instead of doing it seperately for all companies I want the financial for all companies in one file.

Is that possible?

 

[healey21]

Hi you can set this up as an Array selecting the Sheets and then print to PDF which will combine all the sheets into a single pdf file.

Example

Sub MakePDF1A()
Dim FileName As String
FileName = "C:\VBA\Test1"
ThisWorkbook.Sheets(Array(1, 2)).Select
ActiveSheet.ExportAsFixedFormat xlTypePDF, FileName & ".pdf", , , False
End Sub

 

[jnvm90]

That would work if I had my calculations in different sheets but the issues is that I want to print sheet 1 with one set of values then update sheet 1 with another set of values and then collate.