code to export pivot table to excel

T

taps54

I currently have a form that has a pivot table on it and I would like to
automatically export to a spreadsheet in a specific directory when the form
opens. On the form is a comand to export the pivort table to excel. Has
someone written any code that this can be incorporated into the on focus or
on open properties within the form. Thanks for the help.

Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top