[VBA] How to create a PivotTable using an OLEDBConnection whose Data Source is ThisWorkbook

I'm trying to use VBA to create a PivotTable, using an existing WorkbookConnection(OLEDBConnection). Here is what I found: If the "Data Source" of the Connection String is outside ThisWorkbook, the...