Exporting Pivot Table (1 Viewer)

[waxdart23]

I use the following code to export (from a form) the results of a saved query (Hoursworked) to Excel.

    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "HoursWorked", "C:\path\hoursworked.xls"
    MsgBox "Hours Worked Exported.", vbInformation, "Message"

I know have a pivot table which I wish to be able to export similarly from a form but it doesnt as a Pivot table is a form.
I can't even preview the pivot table (so the user can just click on the "export to Excel" button) from a form as it opens in form view rather than pivot table view.

Anyone any ideas on a solution to my problem.