Hi
I have a Data Access Page with a pivottable that I export to excel once a month. I want to alter the "export to excel" button in the DAP file to activate a macro in excel to run as soon as the pivot table finished exporting to excel. The excel macro will format the Pivottable and add some extra data.
Can I alter the button and how? Don't know anything about Microsoft Script Editor
Any help will be appreciated
Thanks
I have a Data Access Page with a pivottable that I export to excel once a month. I want to alter the "export to excel" button in the DAP file to activate a macro in excel to run as soon as the pivot table finished exporting to excel. The excel macro will format the Pivottable and add some extra data.
Can I alter the button and how? Don't know anything about Microsoft Script Editor
Any help will be appreciated
Thanks