VBA create pivotcache from another XL file

[cferart]

This maybe too ambitious.
I have 2 workbooks.

Workbook A has new data added weekly and Pivot tables refreshed.

I would like Workbook B to refresh its Pivot tables from the data in Workbook A.

I am newish at VBA, I have been trying to work out how to use the PivotCaches.Create method to Get Workbook B to refresh its PivotCache after new data is added to Workbook A.

I wonder if I can in VBA use the PivotCaches.Create and the SourceType xlExternal to set the path to Workbook A eg I:/lis/bus/statistics/busstats.xlxm

I have looked at help and searched the web.. but cannot see how this is done

any help most appreciated.
Thanks
Catherine