Hi, I have an Excel template which contains a Pivot data which will be refreshing by a tab after i am exporting a query to raw data in the workbook.
E.G
raw-data (getting from query)
pivot-data (refreshed by query)

1) I would like to know how can I get the code for exporting the query on excel using parameters by Access form
2) How can i use the template file after the exporting to be refreshed on the pivot table.

I am really appreciate any help from you. I would prefer not using transfer method.

Thanks.