EXCEL - SLICER
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-04-18 05:46 PM
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.
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-04-18 01:01 AM
SOLVED
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
18-06-18 08:49 PM
i have the same problem, how can we solve it?
