Hi all
I have a Macro that cycles through selecting items in a listbox, this then updates a pivot table chart.
I have a requirement to us the same macro to export the updated chart to a PDF file so it can be emailed.
This system has to happen with no manual intervention.
The selection part is done however I am not able to get the chart exported.
Any assistance with the code to export will be greatly appriciated.
Regs
Dave
