First, I must admit defeat. While it may be temporary I was hoping that this forum could possible point me in the right direction.
I currently am working with two files.
The first file is a template that acts as a pseudo BI tool.
The second file is a data source that drives the information of the template.
I have created a Macro that makes the opens both files writes their filepaths to the "Intro" worksheet.
The second worksheet then activates and creates a dynamic range to be used in the PivotCache which hopefully will drive the PivotTables. Every PivotTable runs from the same PivotCache.
The issue I am having is twofold.
First it appears that the PivotCache is not being created so there are most definitely flaws in my coding. Second the code runs but it returns either an Error 13 Type Mismatch or when I change the ptRange to ptRange.Address it gives me this long convoluted string that essentially says I don't have my data set up correctly. (Run-Time error -2147024809 (80070057)
I have included my code for any insight. Thank you very much.