Automation of printing in PDF a pivot table

[Saintor]

This would be a weekly report.

I can already trigger an event (Windows Task) at start-up using the equivalent of a command parameter, as in MS Access.

I need a way to automatically set the filter of my pivot table with a range of dates (...previous week) and print a PDF.

Any inspiration would be appreciated!

[dflak]

As for setting the range of dates, I recommend using a helper column in the source data =AND(Date>=StartDate,Date<=EndDate). This will evaluate to True when the date is between the start date (first date last week) and end date (last date last week) regardless of what those dates are. Use this as a fixed filter for the pivot table and you will be spared the agony for trying to set the individual dates in the Pivot Table. Hint: Today() - Weekday (Today()) always gives last Saturday's date.

As for printing a PDF out of it, record a macro to do that and then modify it to meet your needs.

This is as far as I can take it without a sample workbook.