Author Topic: Basic script for Excel Slicer automation  (Read 2618 times)

stanl

  • Pundit
  • *****
  • Posts: 936
Basic script for Excel Slicer automation
« 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.


Deana

  • Wilson WindowWare Tech Support
  • Pundit
  • *****
  • Posts: 1183
  • WinBatch® can do it.
    • WinBatch Tech Support Database
Deana F.
Technical Support
Wilson WindowWare Inc.

stanl

  • Pundit
  • *****
  • Posts: 936
Re: Basic script for Excel Slicer automation
« Reply #2 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.