Basic script for Excel Slicer automation

Started by stanl, May 26, 2014, 06:10:23 AM

Previous topic - Next topic

stanl

I have been quoted as saying "Slicers are no more than filters that went to beauty school", but while filters are great for analysis, slicers seem to be a hit with presentation.

The attached script is very basic and should work with most WB versions in the last 5 years, but does require Office 2007+ to test.


Deana

Deana F.
Technical Support
Wilson WindowWare Inc.

stanl

Deana;

Made the script more generic. Attached now asks for workbook to examine and either returns slicers or no slicers found.