Filter Pivot tables with "Contains" statement and save workbook with invoke code

Help
1

Hi guys,
i have some questions regarding Pivot Tables in excel.

how can you filter the data of a pivot table using “Contains” with this PivotField?

oPivotField=CType(oPivotTable.PivotFields(“Texto”),Microsoft.Office.Interop.Excel.PivotField)
oPivotField.Orientation=Microsoft.Office.Interop.Excel.XlPivotFieldOrientation.xlPageField

I tried with this:

oPivotField = ws(“App”).PivotTables(“Summary_App”).PivotFields(“Texto”)
With PTfield
.ClearAllFilters
.PivotFilters.Add xlCaptionEquals, , “App”
End With

But i can’t use ws (Worksheet variable) because it can’t be indexed

Also when i use WorkBook.Save() in another flow there is a pop up that ask me if i want to replace the book, i click yes but it doesn’t replace the file.