I found a way to do it, it seems to work, but I can't test it just yet...
I'm having another problem because of the read-only settings on the files I have to access. I have to change the field from a pivottable to get another "set" of data.
wbExcel.ActiveSheet.PivotTables("PivotTable5").PivotFields("Model").CurrentPage = "xxx"
I'm getting this error "Unable to set the _Default property of the PivotItem class".
Is there a way I can work around this? I really need to find a way to make it work this way, maybe if there's a way to save a temporary copy locally and open this file... but I need to delete it afterwards.
This is really important and I need a solution really fast and I'm kinda tired of looking for a way to do it...