HELP!! automate excel pivot table from acces
 

Hi I am fairly new to access programming and really need help.
I have an access application which requires excel report functionality.
I need the following functionality
On users click
open a dialog box which allows the user to pick an existing file or
create a new excel file.
Once the user choses the file, I need to transfer results of a query in
access into that file and then create a pivot table based on the
results.
Please advise of the best way to code this out.
I am able to successfully transfer the results of the query to the
specified file, but then not sure how to keep the file open and create
a pivot. Please advise all help is greatly appreciated.
thanks
jen