I'm sorry if this exists somewhere, I cannot find an answer that works for me.
I am writing a program to save a sheet with a pivot table as a pdf. The pivot table has a slicer and I need to save a sheet for specific options in said slicer (only one selected at a time). I have the code to save as a pdf all ready, the only issue is that I would like to save the name of the pdf as the name of the slicer selection, but I cannot find out how to return the name or value of the selected slicer. Can anyone help me be able to return the value?
I am writing a program to save a sheet with a pivot table as a pdf. The pivot table has a slicer and I need to save a sheet for specific options in said slicer (only one selected at a time). I have the code to save as a pdf all ready, the only issue is that I would like to save the name of the pdf as the name of the slicer selection, but I cannot find out how to return the name or value of the selected slicer. Can anyone help me be able to return the value?