+ Reply to Thread
Results 1 to 4 of 4

Print Pivot table for each value in the report filter. All at once

  1. #1
    Registered User
    Join Date
    11-06-2020
    Location
    Madrid, Spain
    MS-Off Ver
    365
    Posts
    2

    Print Pivot table for each value in the report filter. All at once

    Hi!

    I have built an VBA Macro to print a pivot table for each value selected in the report filter. The code is this:
    Please Login or Register  to view this content.

    It does want I want, except it prints each one in a different PDF, so when I run the Macro, I need to choose a name for the PDF file and accept to save it. So this dialog opens many times (one for each value in the report filter). Any ideas how can I do it all at once? I mean to save all the pdf's without the need to choose the name and click Save for each of them, because we are talking about 500 prints.

    Thank you very much!!
    Last edited by alansidman; 11-06-2020 at 05:36 AM.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,757

    Re: Print Pivot table for each value in the report filter. All at once

    Code Tags Added
    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-06-2020
    Location
    Madrid, Spain
    MS-Off Ver
    365
    Posts
    2

    Re: Print Pivot table for each value in the report filter. All at once

    Ok, Thanks

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,876

    Re: Print Pivot table for each value in the report filter. All at once

    As you are using .PrintOut, you are presumably outputting to the default printer and that is a .pdf printer, like Bullzip? That means control of the "printer" is external to Excel and (probably) cannot be controlled in Excel.

    You could try saving each page as a .pdf file and naming it within Excel. Use Application.DisplayAlerts = False to accept defaults.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 04-24-2020, 04:56 AM
  2. Help: Print Pivot Table Report TO pdf. BY Filter AS Separate Page
    By happydays886 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2017, 10:21 AM
  3. Replies: 0
    Last Post: 07-14-2016, 03:51 PM
  4. Filter in Pivot Table's Report Filter
    By mxlew in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-10-2015, 12:46 AM
  5. [SOLVED] How to set a 'Date Filter' on a field in the 'Report Filter' section of a Pivot Table?
    By Rhino_dance in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-28-2013, 11:01 AM
  6. Replies: 0
    Last Post: 11-18-2011, 07:31 AM
  7. Place a number filter on a report filter in a pivot table
    By reuben.doetsch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2010, 12:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1