Exporting Chart with macro

[#1]

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

[suniljain]

I Implemented Whole scenario for PPT but donot know For PDF . because I donot have PDF creato license.