VBA macro - pivotchart to be outputed as a PDF

[Gary]

I have a database that creates graphs based on my data.

I have created a macro using the PRINTOUT command and it
requests the output filename for each entry.

Does anyone have a process to include the "output
filename" in the macro?

This will allow this macro to run with no human involement.

 

[SA]

Gary:

There's no built in way to output your Pivot Graph or Pivot table to a PDF
file and automate specifying a file name.

However, the PDF Pro Plus edition of our PDF and Mail Library for Access can
allow you to do this with vey minimal code, provided that your Pivot Table
or Chart is based on a basic table or on a form. You'll find it on our web
in the developer tools section.