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

[AlfredQuick]

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!!

[alansidman]

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.)

[AlfredQuick]

Ok, Thanks

[TMS]

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.