Remove DataField in Pivot table using VBA

[AnilPullagura]

Pros,

Am trying to change the datafield in a pivot table using VBA, I was able to add a new field but the old field is not getting removed.

The following code throws an error "Unable to set the Orientation Property of the PivotField Class".

ActiveSheet.PivotTables("PivotTable1").PivotFields("Document ID").Orientation = xlHidden

I churned my brain, but unable to find the reason for this error. Please guide me.

Thanks,
Anil

 

[MicaRunner]

Was able to figure it out modifying the code found on https://www.thespreadsheetguru.com/blog/2014/9/27/vba-guide-excel-pivot-tables