Export query param from Access form 2 XLS template
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.
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.