Hi,
I want to export queries, pivot tables from ACCESS to EXCEL using VBA codes.
and i want to export them to specific places in excel spreadsheets. like i want to export two different query recordsets into one worksheet and put them in specific places. how to achieve that?

for now, i only have
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tbl_lookup_ird", "c:\temp.xls", True

but i dont know to how to export pivot table using VBA, and i dont know how to put them in specific places.

thanks a lot in anticipation.