Save pivot as a pdf and name it according to the value in a cell

[rcdavis28]

Really Struggling. Below is what I have so far. I got this code to run correctly once and have not been able to get it to run correctly again.

Please Login or Register  to view this content.

I know what I am missing needs to go there between the " and .pdf", Quality part. I have one filter in my pt. The value of the filter is in cell B2.. all i want to do is save the pdf as the value of the filter name in cell B2 and have it save to directory instructed.

[dflak]

Looks like a syntax error to me.

Please Login or Register  to view this content.

[rcdavis28]

Yes. That's the error I keep getting, but how to fix it.

[rcdavis28]

Instead of My File Name, how tell it to pull the value from the filter in the pivot table (Cell B2) and make that the name of the pdf file.

[dflak]

If Cell B2 has "My File Name.pdf" in it, then it becomes:

Please Login or Register  to view this content.

[rcdavis28]

Your method seems completely logical, but I keep getting Automation error.. The filename, directory name, or volume label syntax is incorrect. Run time error

[dflak]

I'll have to see the rest of the workbook.

At Sheets("SheetName") you should be using your own sheet name. If you eliminate this, the program will look at cell B2 on whatever sheet it thinks is current.