VBA Exporting SQL PivotTable view to Excel

  • Thread starter William E Hannon Jr
  • Start date
W

William E Hannon Jr

I am trying to export an Access SQL in PivotTable View via VBA to Excel, I
found the VBA:

Me.PivotTable.Export "file.xls", plExportActionOpenInExcel

But I am using an SQL in PivotTable view ... which does not recognize the
"Me". How do I find the PivotTable object from the "view" via VBA??
 
Top