code to export form pivot table to spreadsheet

[Tony1258]

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