How do I access a Pivot Table using VBA for EXCEL when the pivot .

I am trying to write a macro to lookup data in a pivot table, but the pivot
table is in another workbook other than the one I am currently working in.
Do you have any sample code for doing this?