Hi, why its not wotking?
If i put the slicer name to the code manually its working, but if i use the slicer name from dataitem (text) than its not working with error:
Internal : Could not execute code stage because exception thrown by code stage: The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
Dim wbslc as Object = wb.SlicerCaches(Slicer_name) 'input from data item not working. Its takes the name from dataitem (text) and is used as input for the code again as text.
'Dim wbslc as Object = wb.SlicerCaches("Slicer_Sectore") 'input manually working fine, exactly same name as in the dataitem.