• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Print or Save as a PDF for each item in Pivot Slicer using VBA with Single Click Button

Manster

Member
Hi Experts,

I have 20 items in the slicer pivot. Therefore, I want to print or save as a PDF for each item (in a separate file), as you can see in the tab sheet "Report" on my excel file (Sample.xlsx) below.
Is there any code to run this?

Your kind attention is really appreciated. Thank you in advance!
 

Attachments

  • Sample.xlsx
    22.6 KB · Views: 3
Select a file in any application that prints and open it.
Choose “File” > “Print”.
Choose “Adobe PDF” from the list of printers in the print dialog box.
Click "Print" to use the Acrobat PDF printer.
Click “OK” and enter a new file name for your PDF. Save to your desired location.

Hope This Works,
Peter
 
Back
Top