Basic script for Excel Slicer automation

[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]

Thanks for sharing! Posted the sample to the tech database: http://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/tsleft.web+WinBatch/OLE~COM~ADO~CDO~ADSI~LDAP/OLE~with~Excel/Samples~from~Users+Basic~iteration~of~Slicers~in~Excel.txt

[stanl]

Deana;

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