Pivot Table Programming Needed

Hi

I need some help on pivot table programming. My purpose is that the vba code should read a column with names in one excel workbook and select the same names in a particular pivot field in another excel workbook. There are hundreds of names and if done manually it takes a lot of time to manually select the names (pivot items) in the pivot field.

Here is my code

Please Login or Register  to view this content.

When I run the above code I get the run time error message 1004 that says
"Unable to get the pivotitems property of the pivot field class"

Please help me out with this error as this work done manually is taking a lot of my time.

Thanks in advance
Bluelotus