Selecting PivotItems from another sheet

I'll let you know up front that this is cross-posted here: http://www.mrexcel.com/forum/showthread.php?t=536608, because this forum wouldn't let me in earlier (Database Error, it said). No one has responded at the other posting, so I thought I'd try here.

The problem: I need to alter a Pivot Table via VBA. What I need to do is change the PivotItems in the MOS2 PivotField; these are expenses by month, with the Months noted as "01","02"..."12". On another sheet, in another workbook, I have the list of months I want to see. I tried doing it by using the code below, but it fails with the message

Please Login or Register  to view this content.

Any help I can get on this is greatly appreciated. I've been searching for two days on the internet and can't find any help for this one, so you're my last hope.

Thanks,
John

Please Login or Register  to view this content.

Try putting in a .Text after the range.

Please Login or Register  to view this content.

If that doesn't work then try to use the index of PivotItems.

Like
If .PiviotItem(i).name = Vlookup.... then make visible = true.

BTW - I've found you can't make all Visible = False as the Pivot Table will complain and code stops.

hope this helps.