Creating numerous PDFs

[cogswel__cogs]

I created a dashboard for my company and they like it.
I added a print and Pdf buttons allowing you to print out or PDF a view.

They asked if there was a way to Create a file with all views in PDF. So I said I don't know I will have to check my magic 8ball.
So I am posting here which basically is my magic 8ball.
Is there a way with VBA to create PDF after PDF saving as the same PDF file.

 

[mole999]

saving as the same will overwrite won't it

 

[cogswel__cogs]

I want to go to the next page of the same pdf file.
Like the way it happens when you PDF multiple sheets.

 

[mole999]

Have you tried recording a print to PDF
2007
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
Sheets("OPs Licences as of 01-Feb-2018").Select
2016
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\mauri\Desktop\AfC 2 test bed.pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
True
Gone are the days of having to have adobe installed

 

[cogswel__cogs]

I think the code I manipulated is similar.
However I want to run numerous instances and save them page after page.
I would be just as happy wit JPGs as I could design something in excel to run them page after page with VBA code.
However the dashboard has numerous slicers. When I print out the slicers are replaced by text, as text better displays what has been chosen or not chosen.
When I designed I just told the Pivottables to not be included when printing and have it replaced by text.
So if I go to copy the dashboard as a picture the slicers remain. So it is much easier to work with printout but I only am aware as printing as pdf or to a printer.