Exporting Pivot Chart in a subform as a picture

W

Walter

I got a form and within that form is a subform containing a pivot chart. I
want to create a button on the parent form such that when user click on this
button, pivot chart in the subform (applied with user filters) is exported as
a picture to specified directory. First question is how to use VBA code:
Me.PivotChart.ExportPicture "C:\...", , 1024,1024
on a subform

Second question how can I allow user to browse the directory so that they
can choose where they want to store the picture.

Thanks heaps
 
Top