Hello, I was hoping someone could help me with exporting a pivot table created in Access to export and save to an excel
The current code I have in place works fine, however, I have to specify the location and "saveas" type each time I want to
export the pivot table to excel:
DoCmd.OpenQuery "User_Authorization", acViewPivotTable
DoCmd.Close acQuery, "User_Authorization"
I've used the docmd.transferspreadsheet method in the past and don't know if there is another method for the pivot
Is there an easier way of doing this? I would like to export the pivot table(s) because there is about 20 I have to do for
each autorization group. I'd like to make it faster where I can loop through the records.
Any help/suggestions would greatly be appreciated.