Modify export function of DAP

Batten

New member
Local time
Today, 12:35
Joined
Aug 7, 2008
Messages
7
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
 

Users who are viewing this thread

Back
Top Bottom