WinBatch® Technical Support Forum

Archived Boards => COM Automation and dotNet => Topic started by: stanl on May 26, 2014, 06:10:23 AM

Title: Basic script for Excel Slicer automation
Post by: stanl on May 26, 2014, 06:10:23 AM
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.

Title: Re: Basic script for Excel Slicer automation
Post by: Deana on May 27, 2014, 07:28:04 AM
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
Title: Re: Basic script for Excel Slicer automation
Post by: stanl on May 30, 2014, 12:18:13 PM
Deana;

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