exporting to excel the current selection

[shree909]

Hi ,

i want to create a button , and when that button is clicked  a pivottable chart should get exported to excel

.is ther a way that it can be done..

if possible all the current selections are also exported to excel??

Thanks

[#2]

You can use a macro to export the table to Excel and then a variable to bring over your current selections.  See attached.