pivot table control in VBA

[etk]

supposing that I create a workbook and export a query to excel that is a table of information about a particular employee is it possible to generate a pivot table and modify the pivot table in that same module, or does one need to open excel and create this? any hints

 

[JHB]

What do you mean with "modify the pivot table in that same module"?
If it is the result, then yes - if you put the query result in a table, else you can't edit/modify the result in MS-Access.