I know it's old but, for anyone else that may look at this.
I'm Not a guru at access or VBA (or anything for that matter) but I just use a typical macro to open the report and runcommand to PivotTableExportToExcel
Maybe that will help someone, someday