1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Sub SelectItems()
Dim sI As SlicerItem
For Each sI In ActiveWorkbook.SlicerCaches("Slicer_Client_Name").SlicerCacheLevels.SlicerItems
Sheets(Array("Assets - Overview", "Liabilities - Overview")).Select
Sheets("Assets - Overview").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Quality:=xlQualityStandard, IncludeDocProperties:=False, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
Sheets("Liabilities - Overview").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Quality:=xlQualityStandard, IncludeDocProperties:=False, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
Next
End Sub |
Partager