exporting to excel the current selection

shree909 — Thu, 06 Dec 2012 19:28:32 GMT

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

Re: exporting to excel the current selection

Thu, 06 Dec 2012 20:54:24 GMT

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